Difference Between Oracle 11g , 12c, 18c, 19c Versions And New Features

 Version 11 g 

1. 11g have not PDB (Pluggable Database)

2. 11g (g for Grid Computing)

3. Released in 2008

4. Dose Not have Cloud Support

5. Oracle 11g does not provide in-memory capabilities

6. No JSON support 

Version 12c 

1. 12c starts PDB 

2. 12c (C for Cloud)

3. Released in 2014 

4. PDB and multitenant architecture

5. Starts Cloud Service

6. Oracle 11g provide in-memory capabilities

7. Support JSON

8. Better performance in input/output then 11 G 

NEW :

1.Online migration of an active data file

2.Online table partition or sub-partition migration

3.Invisible column

4.Multiple indexes on the same column

5.DDL logging

6.Temporary undo in- and- outs

7.New backup user privilege

8.How to execute SQL statement in RMAN

9.Table level recovery in RMAN

10.Restricting PGA size

Version 18c

1. Starts Autonomous Database (self-driving, self-securing,self-reparing)

2. Released in 2018

3.Manage private temporary tables

4.Use the Data Pump Import CONTINUE_LOAD_ON_FORMAT_ERROR option

5.Convert a HASH partitioned table to a RANGE partitioned table, online

6.Convert a LIST partitioned table on two keys to a LIST AUTOMATIC partitioned table on one key, online

7.Convert a LIST AUTOMATIC partitioned table to a LIST AUTOMATIC partitioned table with SUBPARTITIONING, online

8.Merge partitions of partitioned tables online

9.Use batched DDL

Version 19c

1. Released in 2019

2. Query Quarantine

3. JSON Support  (Intrudesed new JSON functions)

4. Automatic Indexing

5. Hybrid Patitioned Tables

6. Active Data Guard

7.19c is the final 12.2 release (equivalent to 12.2.0.3)

8.19c can be deployed as a BM, VM or Exadata database, or as Autonomous

9.Deploying currently uses on 19c by default

10.To benefit from Autonomous Database features, it must be specifically selected during DBS creation