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