Wednesday, October 2, 2019

Oracle - 2 onenote lbm


<<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






Description of Figure 15-1 follows




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