History of Oracle Database

In this post we will come to know about all versions of Oracle database. what features added in all versions with year. 

History of Oracle Database

In 1970 E.F Codd introduce relational data model is collection or relation of two dimensional tables. Relational data model mainly consist of 3 components:-

1. Collection of object
2. Set of operators
3. Data integrity rules

SQL:

It is a non-processor language which is used to communicate with all type of data bases. Such as oracle, SQL server, DB tools etc.

• This language was developed by german scientist E.F Codd in 1968 and ANSI aooroved this in 19970 and SQL was released in market 1972.

SQL Versions:

1. SQL
2. pl/sql
3. Dynamic SQL

Versions of ORACLE database with all features:

1. Oracle 2.0(1979):  

                          a) First public Release   

                          b)Basic SQL functionalities

2. Oracle 3.0(1983): 

                        a) Commit, Rollback  

                        b)Rewritten language C

3. Oracle 4.0(1984):
                       a) Read Consistency
                       b) Export/Import utilities
4. Oracle 5.0(1985): 
                      a) Introduce Client Server architecture
5. Oracle 6.0(1988):
                      a) Introduce pl/Sql
                      b) row level locks
6. Oracle 7.0(1992):
                      a) Roles
                      b) Integrity constraints
                      c) Stored Procedures
                      d) Stored Functions
                      e) Trigger
                      f) Package
                     g) Varchar data type change into varchar2 h) view compilation
7. Oracle 7.1(1994):
                     a) Dynamic SQL
                     b) ansi/iso SQL
8. Oracle 7.2(1995):
                    a) inline views(Sub query used in form clause)
                    b) Ref cursor(cursor variable)
                    c) DBMS-job package
9. Oracle 7.3(1996):
                   a) Bitmap indexes
                   b) utl_file package
10. Oracle 8.0(1997): 
                  a) Object Technology
                  b) nested table, varray
                  c) Columns increased per a table up to 1000
                  d) instead of trigger
11. Oracle 8i(i= internet) 1998: 
                  a) Materialized Views
                  b) Function based Indexes
                  c) Rollup, cube
                  d) Bulk bind
                  e) Analytical function
                  f) Autonomous transmissions
12. Oracle 9i(2001):
                 a) remaining column
                 b) Merge statement
                 c) 9i joins or ANSI joins
                 d) Flashback query e) Multi table inserts
13. Oracle 10g( grid Technology)2003:
                 a) Recyclebin
                 b) Flashback table
                 c) Regular expressions
                 d) indices of clause
                 e) rename tablespace
14. Oracle 11g(2007):
                  a) continue statement introduced in pl/sql loops
                 b) read only tables
                 c) Virtual columns
                 d) Pivot () function
                 e) Introduced Simple_integer datatype in pl/sql
                 f) Sequences are used in pl/sql without using dual table
                 g) Introduced compound triggers
                 h) enable, disable clause introduced in trigger specification.
                  i) name, mixed notations used in a sub program executed in select statement.

In next post we will start the basic concept of SQL with some good example. 

               

Bookmark this site and stay tuned with us for more post related to SQL.