IN-MEMORY In Oracle 12c

Introduction :- Oracle 12c has lots of characteristics  In-Memory is one of the most important features.  It enables tables, partitions, materialized views be stored in memory using column format, which delivers fast SQL processing for the Analytical purpose. Oracle Database In-Memory proffers an idiosyncratic dual-format architecture that legalizes tables to be concurrently represented in memory using standard row […]

Read More

Truncate table with cascade feature1 in oracle 12c

In oracle 12c TRUNCATE TABLE CASCADE will truncate its child tables, if ON DELETE CASCADE relationship is present on child table. Create one parent and child table with some data

You can check the child table details using : Get child table details

Truncate the parent table with cascade option:

We can […]

Read More

Row limiting clause in oracle 12c

Row limiting clause clause allows sql queries to limit the number of rows returned and to specify a starting row for the return set. 1. Fetch first N rows:

2. Fetch 5 rows after offset of 4 rows

3. Fetch percentage of rows from a query:

Read More