Add

Versions of Oracle, Oracle Release Dates, Oracle Technologies.

4:19:00 PM Rohit Kumar Verma 0 Comments

Oracle Versions

1. Oracle 2.0 --------> 1979--------> First Public Version-----------> Basic sql functionality, Joins.

2. Oracle 3.0----------> 1983--------> commit, rollback----------. rewritten in c language.

3. Oracle 4.0 --------->1984----------->read consistency.

4. Oracle 5.0 ----------> 1985----------->Client-Server Architecture.

5. Oracle 6.0 -----------> 1988---------> PL/SQL------------> row level locks.

6. Oracle 7.0 -----------> 1992 --------> datatype varchar changed to varchar2----------------> Stored         procedures---------> Stored Functions----------> triggers-----------> Integrity Constraints---------->       truncate command--------->roles-------------> view compilations.

7. Oracle 7.1 ----------1994-----------Introduced dynamic SQL---------->ANSI/ISO sql92.

8. Oracle 7.2 --------->1995---------->in-line views---------->ref-cursors or variables-------------->DBMS job package.

9. Oracle 7.3 ---------> 1996 -----------> util file package------------> bitmap indexes.

10. Oracle 8.0 ----------> 1997 ---------> Object Technology-------->lobs(large objects) ----------> triggers----------> column increased for a table upto 1000( before it was 256)-----------> Partitions tables , indexes

11. Oracle 8i---------> (i=internet)-----------> 1999---------> materialized views------------> case conditional statements -----------> rollup , cube-----------> trim()------------> bulk bind-------------> function based indexes-----------> Analytical functions-------------> Autonomous transactions.

12. Oracle 9i---------> 2001---------> merge Statements ---------> ansi joins or 9i joins-----------> renaming a column -----------multitable insert ------------> flashback queries ---------> NVL2(), nullify().

13. Oracle 10g----------> 2003-----------> grid technology--------->Recycle Bin----------> falshback table ( same as restore from recycle bin.)-------------> indices of clasuse------------> wm_concat()--------> regular expressions.

14. Oracle 11g--------> 2007-----------> introduced continue statement in pl/sql loops. ---------> read only tables are introduced ---------> virtual  columns ----------> pivot() functions ----------> simple integer datatype in pl/sql------------> compound triggers---------> follows clauses in pl/sql triggers --------> enable, disable clause used in pl/sql triggers specifications--------> sequences are used in pl/sql without using dual tables.-----------> named, mixed notations used in sub programs, executed using select statements.

15. Oracle 12c -------> ( c= Cloud computing)---------2013----------> invisible columns-----------> Identity columns ------------> default values----------> sequence session-------> top n query--------> fetch first clause--------------> truncate-----------> table cascade------------> sql with functions

0 comments: