Thanks to tom - A Challenge

The source for this article can be found in this link:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:516338600346572071

 

Although this challenge was posted in past, I thought to revive its magic. It was posted by Tom Kyte on Oct 31, 2007 4:52 AM. Without Tom or even AskTom I don’t think Oracle geeks would have some good repository of technical advantage. Here in this article I will rephrase and revive the magic of a small challenge for Oracle geeks. Find out from the following list of versions and features, when they where introduced in Oracle.

 

Of course you could read the link above and find the same. But try this as an exercise, and you will be surprised (for most of geeks they will find new features, for others they will battle with their memories).

 

Okay enough for the occasion, here is the features list:

 

1 Real Application Testing

2 Read only Replication

3 Distributed Query

4 Drop column

5 Client-Server (where the client could be elsewhere in the network)

6 Object Relational Features

7 Ability to return result sets from stored procedures (ref cursors)

8 Commit and Rollback (transactions)

9 Triggers

10 Function based indexes

11 Materialized Views

12 Rman

13 Audit SYSDBA/SYSOPER activity

14 Automatic Undo Management

15 Resumable Operations

16 Automatic Storage Management (ASM)

17 Streams

18 Bitmap Indexes

19 csscan - Character Set Scanner utility

20 Flashback Query

21 Case statement (IN SQL, instead of decode)

22 Parallel Query

23 Transparent column level encryption

24 Tablespace encryption

25 PL/SQL

26 Partitioning

27 Row Level Locking

28 Read Consistency (my favorite feature!)

29 2 Phase Commit

30 Sorted Hash Clusters

31 Conditional compilation for PL/SQL

32 Connect By Queries (select ename, level from emp connect by prior....)

33 Update anywhere Replication

And here is the version list:

10.1

10.2

11.1

2

3

4

5

6

7.0

7.1

7.2

7.3

8.0

8.1.5

8.1.6

8.1.7

9.0

9.2

 

Have fun in interpreting numbers and your memory.