0 
0 This paper presents a compilation of quirky questions, tantalizing puzzles and cheeky challenges that will have you wander among many interesting, useful and often surprising features and functionality, sometimes as old as Oracle 7.2, yet often overlooked and forgotten. While some of the stuff will challenge and astound even seasoned developers, most can be understood and appreciated by developers with intermediate programming skills in SQL and PL/SQL. I assure you that anyone reading will have ‘since when is that possible’ experiences!
Many of the topics in this paper are not entirely my doing. I do not live on an island and there are so many excellent writers on the internet that write articles, tips, suggestions etc. that have heavily inspired me. Tom Kyte, his books and his AskTom website should really be mentioned here.
By the way, most examples are taken from the Oracle 7Up workshop that we have developed at AMIS, to help Oracle developers familiar with SQL and PL/SQL as it was in Oracle 7, quickly get up to speed with the many really useful features that have been added ever since.
Download the paper:amis_odtug2005_waterburning.doc
Related posts:
Poor man's VPD – Virtual Private Database before 8i and in Standard Edition Databases Oracle 10gR2 – Conditional PL/SQL Compilation 
Dynamic SQL Pivoting – Stealing Anton’s Thunder Putting Analytical Functions to good use – find tables with multiple foreign keys to the same referenced table Pimp you SQL Developer
Hi I want to take the quiz to improvize my skills in SQL and actually want to know whr do i stand in SQL
Hi,
I want to take the quiz on SQL for understanding/updating my knowledge
Thanks
Hi,
I want to take the quiz on SQL for understanding/updating my knowledge
Thanks & Regards
Monicka KUmar
hi it is nice program
i wanna quiz in oracle
As far as I can verify, “ORDER BY” in inline views was only introduced in 8.1.5. The article may lead readers to believe that it’s been around for longer.
Interesting read as usual though…