Oracle version with new Features Oracle 2.0 to 12c. - Deepak YT

Oracle version with new Features  

1) Oracle 2.0 (1979) 

• First public release 
• In this 2.0 only basic SOL functionality is there "joins" 

2) Oracle 3.0 ( 1983) 

•  Rewritten in C language 
•  Commit, Roll back 

3) Oracle 4.0 (1984) 

•  Read consistency 
• Exp/imp utility programs [export/import] 

4) oracle 5.0 (1985) 

• Introduce client server architecture 

5) Oracle 6.0 (1988) 

• Introduced PL/5QL 
• Row level locks 

6) Oracle 7.0 (1992) 

•  Roles 
• Integrity constraints 
• Stored Procedures 
•  Stored Functions 
• Packages 
• Triggers 
•  Data type "varchar" changed into "varchar2" 
• Truncate table 

7) Oracle 7.1 (1994) 

• Introduced dynamic SOL 
• ANS/ISO 50L-92 

8) Oracle 7.2 (1995) 

• Inline views or sub-queries used in from clause 
• Re cursor (cursor variable) 

9) Oracle 7.3 (1996) 

•  Bit map indexes 
• Utl_file package 

10) Oracle 8.0 (1997) 

• Object technology 
• Columns increased per a table up to "1000" 
• Nested table, varray 
• Large object (Clob,Blob,bfile, data type) 
• instead of triggers 

11) oracle 8 (i- internet) ( 1999) 

•  Materialized views 
• Function-based indexes 
• Case conditional statements 
• Analytical functions 
• Autonomous transactions 
• Rollup, cube 
• Bulk bind 
• Trim (l function 
• Instead of triggers 

12) 0racde 9i (2001) 

• 9i joins or ANSI joins 
• Merge statements 
• Multi table insert 
• Flash back queries 
• Renaming a column 

13) Oracle 10g (g- grid technology) ( 2003) 

• Recycle bin 
• Flash back table 
• Indices of clause 
• Regular expressions 
• WM_concat() function 

14) Oracle 11g (2007) 

•  introduced contnue statement in PL/SOL loops 
• Read only tables 
• Virtual Columns 
•  Pivot() function 
• Regular expression Conn[)function 
• Compound trigger 
• Enable, disable clauses used in trigger specification 
• Follow clause in triggers 
•  Sequences used in PL/SQL without using dual table 
• Named, mixed notations are used in a subprogram executed used select statement 

15) oracle 12 C (Cc-Cloud Technology) (2013) 

• Invisible Column 
• Multiple Indexes 
• Truncate table ... Cascade 
•  Session specific sequence 
• New, top-n analysis by using fetch first/next clauses 
• New auto increment concept without using row level triggers 
• With clause use in local function 
• Accessible by clause used in stored procedures