Oracle 12c New Features

APPROX_COUNT_DISTINCT Function – Oracle 12c

The need to count distinct values of column is common operation in data analysis. It helps to decide whether an index will be useful or not. Prior to 12c database, we need to execute a query on the table to

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

In Oracle Database 12c, VARCHAR2 and NVARCHAR2 data types supports size up to 32767 bytes. This article explains how to increase maximum size of VARCHAR2, NVARCHAR2 and RAW columns in oracle 12c database using MAX_STRING_SIZE parameter. Prior to 12c version,

Oracle 12c : ENABLE_PARALLEL_DML / DISABLE_PARALLEL_DML Hint

Prior to Oracle 12c if we want to execute DML statement in parallel then we have explicitly enable the Parallel DML at session as given below. ALTER SESSION ENABLE PARALLEL DML; <<execute DML statement>>