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

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

May 9, 2005 Database, IT, Oracle, PL/SQL 6 Comments

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

About The Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.

6 Comments

  1. Akshata August 7, 2007

    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. Ravi January 10, 2007

    Hi,

    I want to take the quiz on SQL for understanding/updating my knowledge

    Thanks

  3. Monicka Kumar July 21, 2006

    Hi,

    I want to take the quiz on SQL for understanding/updating my knowledge

    Thanks & Regards
    Monicka KUmar

  4. raghav August 29, 2005

    hi it is nice program

  5. balaji July 30, 2005

    i wanna quiz in oracle

  6. andrew May 9, 2005

    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…