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
- Oracle 10g's Finest – The Top 3 SQL and PL/SQL Features new in 10g – paper for ODTUG 2005
- Paper on JDeveloper as tool for PL/SQL Development
- Discussion on The Server Side: Comparing Microsoft Yukon (SQL Server 2005, Beta release) with Oracle 10g
- Struts best practices – white paper on JavaWorld
- Eindgebruikers zijn Olifanten – Driedaags seminar â€˜Effective Oracle by Designâ€™door Oracle-fenomeen Ask-Tom Kyte (article from Optimize, March 2005)