<<Temporal Data Samples.pdf>>
Discussion about Max
size of a varchar2 in Oracle
Needs to have a
initialization parameter MAX_STRING_SIZE
to be able to use that
Datatype Limitations
in Oracle
Oracle Technology
Network
Oracle SQL Reference
Migrating from 11g
to 12C
What is a Virtual
Column
Restful Data
Services
Column level
Collation and case insensitive Database
Oracle Documentation
Retail DataModel
Reference
SqlDeveloper
DataModeler
Complete Oracle
Documentation of Oracle Products
ODI - Tutorial for
flat file conversion
Module 1 – Oracle Architecture
![](file:///C:/Users/kajal.somaiya/AppData/Local/Packages/Microsoft.Office.OneNote_8wekyb3d8bbwe/TempState/msohtmlclip/clip_image001.jpg)
![Description of Figure 15-1 follows](file:///C:/Users/kajal.somaiya/AppData/Local/Packages/Microsoft.Office.OneNote_8wekyb3d8bbwe/TempState/msohtmlclip/clip_image002.jpg)
How to Read BLOB
Table Redefinition
to add a column to a table without dropping the table
How to reorder
columns in Oracle using Visible option
Datatypes
Proxy User
Links on Oracle 18 C important
features
ALTER SESSION SET
current_schema=KSOMAIYA;
GRANT SELECT ON
ODS2.BRANCH_MAST to ODS2_READ_WRITE;
select * from
all_synonyms WHERE TABLE_OWNER = 'ODS2';
How to create Schema only
Accounts in Oracle 18C
SELECT username,
account_status,
authentication_type
FROM dba_users
WHERE username = 'ODS2';
SELECT username,
sysdba,
sysoper,
sysasm,
sysbackup,
sysdg,
syskm
FROM v$pwfile_users
WHERE username = 'ODS2';
Privileges on ext
Format SQL Output on
PL/SQL
Schema Only Accounts
Privileges (POC)
CREATE USER
SCHEMAOWNER NO AUTHENTICATION
QUOTA UNLIMITED ON DATA;
GRANT CREATE SESSION, CREATE TABLE, CREATE
SEQUENCE, CREATE VIEW TO SCHEMAOWNER;
ALTER USER SCHEMAOWNER GRANT CONNECT THROUGH
KSOMAIYA;
create role read_schema_owner_role;
grant read_schema_owner_role to ksomaiya;
-- DROP USER SCHEMAOWNER CASCADE;
--
drop role read_schema_owner_role;
Connecting to
Container database
No comments:
Post a Comment