Oracle Versions

Oracle is a combination of SOL and PL/SQL and DYNAMIC SQL

Oracle 1.0 is first but never released in market

Oracle 2.0 1979 first public release It was having basic SQL functionality joins

Oracle 3.0 1984 released in market

Commit, rollback was introduced

Rewritten in c language (to speed up)

Oracle 4.0 1984 released in market

Read Consistency  

Oracle 5.0 1986 released in market

Client –server Architecture was introduced

Oracle 6.0 1988

PL/SQL was introduced

Row level locales

Oracle 7.0   1992 released in market

Integrity Constraints Stored procedures, stored functions, Triggers

Data type varchar changed to varchar

Truncate, views Compilations

Oracle 7.1 1992 released in market

Dynamic SQL

ANSI/ISO SQL- 92 standards

Oracle 7.2     

Inline views, Ref cursors, DBMS job package was introduced

Oracle 7.3  

Bitmap indexes

UTL-file package

Oracle 8.0 1996 released in market

Object technology

Nested tables, Varray

Intend of triggers

Oracle 8. 1 (Internal) 1997 released in market

Functions based indexes

Column Increased per table up to 1000

Analytical function

Autonomous transactions

Rollup, Cube

Case Conditional statements

Oracle 9.0 2001 released in market

Renaming a column

ANSI joins (or) 9i joins

Marge statements

Flashback Query

Multi table Inserts 

Oracle 10.G (Grid technology) 2005 released in market

Recycle Bin Concept

Flashback table

Rename tables’ pall

Indices of clause


Regular Expressions

Oracle 11G 2007 released in market

Continue statement

Read only table

Virtual Columns

Introduce Simple- Integer DT in PL/SQL

Compound Triggers

Follow clause

Sag used in PL/SQL without using dial table

Enable, Disable Query used in trigger specification

Named mixed notations as used in a subprogram

SQL is a Non procedural language which is used to operate All Relational DB product In 1970 EF Codd Introduced ALPHA Language for relational DB In 1970 IBM modified square into square we used in System/R project Again IBM Modified Square into SEQUEL Renamed into SQL

In 1986—ANSI


     1992—ANSI/ISO SQL 92 Standard

     1999—ANSI/ISO SQL 99 Standard

     2003—ANSI /ISO SQL 03 Standard

  Now a days all Companies using 2003 ANSI/ISO Stands