VERSIONS OF ORACLE

ORACLE VERSIONS

1. Oracle 2.0 ------------------ 1979

• First Public release
• Basic SQL functionality, joins.

      2. Oracle 3.0 ------------------ 1983

• Commit, Rollback was introduced.
• Re-written in C language

      3. Oracle 4.0 ------------------ 1984

• Read consistency

      4. Oracle 5.0 ------------------ 1985

• Client-Server architecture.

      5. Oracle 6.0 ------------------ 1988

• Introduced PL/SQL
• Row level locks.

      6. Oracle 7.0 ------------------ 1992

• Varchar datatype can be changed into varchar2 datatype.
• Stored procedures, stored functions.
• Triggers.
• Roles.
• Truncate table.
• View compilation.

      7. Oracle 7.1 ------------------ 1994

• Introduced Dynamic SQL.
• ANSI / ISO sql92

      8. Oracle 7.2 ------------------ 1995

• Inline views
• Ref. cursors (or) dynamic cursors.
• dbms_job package.

      9. Oracle 7.3 ------------------ 1996

• Bitmap indexes
• Utl_file package.

     10. Oracle 8.0 ------------------ 1997

• Introduced object technology.
• nested table, varray.
• LOBS (large objects - CLOB,BLOB,bfile data-types)

    11. Oracle 8i (i - internet) ------ 1999

• Materialized views
• Rollup, Cube
• Trim function
• Bulk bind
• Autonomous transactions
• Analytical functions.
• Column increased per a table upto 1000

   12. Oracle 9i -----------------------2001

• Merge statement
• Renaming a column
• 9i joins (or) ANSI joins
• Multi-table inserts
• Flashback query 

   13. Oracle 10g ( g-Grid technology) ----- 2003

• Introduced Recycle Bin concepts.
• Flashback table.
• Regular expressions.
• Indices of clause
• wm_concat()

   14. Oracle 11g ------------------2007

• Introduced continue statement PL/SQL loops.
• Virtual columns.
• Read only tables.
• simple_integer data-type in PL/SQL
• sequences are used in PL/SQL without using dual table
• compound triggers
• follows clause in triggers
• enable / disable clauses are used in "trigger" specification
• pivot() function
• named, mixed notations are used in a sub-program executed by using select statement

   15. Oracle 12c ( c-Cloud technology) -------2013

• Truncate table cascade
• invisible columns
• multiple indexes on a column through invisible indexes
• session specific sequence
• new auto increment through identity columns
• new top-n analysis through fetch...first/next clauses
• with clause introduced in PL/SQL local functions
• accessible by clause in PL/SQL stored procedures.