Oracle Database

Similar to SQL*Plus DESCRIBE command, RMAN now supports DESCRIBE. RMAN> desc hr.jobs using target database control file instead of recovery catalog Name Null? Type —————————————– ——– —————————- JOB_ID NOT NULL VARCHAR2(10) JOB_TITLE NOT NULL VARCHAR2(35) MIN_SALARY NUMBER(6) MAX_SALARY NUMBER(6) RMAN> If you are connected using the SYSDBA privilege, you can view tables in other schemas, … Read more

Oracle Database 12c, now TRUNCATE statement is enhanced with  CASCADE option. This is pretty useful, that you need not worry about truncating all “child” tables before truncating the parent. With the CASCADE option, Oracle will truncate all tables with a foreign key constraint to the table being truncated. The foreign key must be ENABLED and … Read more