OracleDB12c New Feature: Identity Column

Let’s talk about a “developer” feature today. If you have a need to generate a column value [mostly primary key] based on a sequence, in pre-12c Oracle database we have to create a number data type column in the table, and use a sequence that is separately created. There is no restriction that the sequence … Read more

OracleDB12c New Feature: SQL*Plus NOLOGINTIME Option

Oracle Database 12c has added a lot of features to the database and supporting tools. SQL*Plus is no exception. The login or invoking of SQL*Plus includes more command line options. As in the previous releases, the -H command line option shows the help information. By default SQL*Plus displays the last successful login time, similar to … Read more

OracleDB12c New Feature: More to Online Datafile Move

As we already know, now with Oracle Database 12c, it is easier to move a data file. There is more to it… Let us see few operations in 11g, and how they all got simplified with Oracle 12c online file move feature… 1. Rename a file or move a file from one file system to … Read more

OracleDB12c New Feature: RMAN Describe

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

OracleDB12c New Feature: Cascaded Truncate

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

OracleDB12c New Feature: Store More in VARCHAR2

Starting Oracle Database version 12.1, you can have your VARCHAR2 [and NVARCHAR2, RAW] column width up to 32767 bytes or characters. To be able to use VARCHAR2 columns with more that 4000 bytes or characters [pre-12c maximum], you will need to set the initialization parameter MAX_STRING_SIZE = EXTENDED. By default the value of this parameter is … Read more

OracleDB12c New Feature: New Row Limiting Clause in SELECT

Oracle Database 12c now includes a row_limiting_clause in the SELECT statement. This new clause limits the rows returned in a more meaningful and effective way, compared to the methods available in previous releases [using ROWNUM or using Top-N rows using subqueries or using analytic functions like RANK or DENSE_RANK]. The syntax for the new clause … Read more

Oracle Database 12c – Few Links

Thought of sharing few good links I came across on Oracle Database 12c. Cloud Database Plug into the Cloud with Oracle Database 12c Oracle Multitenant Upgrade, Migrate and Consolidate to Oracle Database 12c Tuning and Optimizer:  What to expect from the Optimizer with Oracle Database 12c(PDF) SQL Plan Management with Oracle Database 12c (PDF) Understanding Optimizer … Read more