Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005

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

6 thoughts on “Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005

  1. Hi I want to take the quiz to improvize my skills in SQL and actually want to know whr do i stand in SQL

  2. 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…

Comments are closed.

Next Post

ADF and J2EE For Oracle Forms and Oracle Designer Developers

Facebook0TwitterLinkedinAnother attempt by Oracle to lower the threshold for Designer/Forms developers to enter the Java/J2EE world. A page with viewlets, articles, news and useful links. Targeted at Forms Developers, this page introduces them to the steps and components required to develop a J2EE application (Oracle ADF style)ADF and J2EE For […]