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 Testing2 Read only Replication3 Distributed Query4 Drop column5 Client-Server (where the client could be elsewhere in the network)6 Object Relational Features7 Ability to return result sets from stored procedures (ref cursors)8 Commit and Rollback (transactions)9 Triggers10 Function based indexes11 Materialized Views12 Rman13 Audit SYSDBA/SYSOPER activity14 Automatic Undo Management
15 Resumable Operations16 Automatic Storage Management (ASM)
17 Streams18 Bitmap Indexes19 csscan - Character Set Scanner utility20 Flashback Query21 Case statement (IN SQL, instead of decode)22 Parallel Query23 Transparent column level encryption
24 Tablespace encryption
25 PL/SQL
26 Partitioning27 Row Level Locking28 Read Consistency (my favorite feature!)
29 2 Phase Commit30 Sorted Hash Clusters31 Conditional compilation for PL/SQL32 Connect By Queries (select ename, level from emp connect by prior....)33 Update anywhere Replication And here is the version list:
10.110.211.1234567.07.17.27.38.08.1.58.1.68.1.79.09.2 Have fun in interpreting numbers and your memory.
