msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Check These SQL Beauties Out

Participation in the Obfuscated SQL Code Contest expired on April 1st. The SQL code that was submitted was not only obfuscated but also beautiful and artful.

When the contest started, I thought that we could just vote on the entries and select the most popular as the winner. But after seeing the entries, I believe that all the participants should be declared winners. Great Work!

Without further ado, here is the list of authors and their scripts:

  • Rob van Wijk: The script requires version 11.1.0.6 because of the pivot operator.

  • Shoblock: The script makes use of subquery factoring and generates rows from dual via “connect by level <”. Tested on 10.1.0.2.0

  • Laurent Schneider: The script requires 10.1.0.5 and cannot be formatted.

  • Frank Zhou: The script solves 4 different puzzles in a single SQL. Requires version 10.2.0.2.0.

  • Volder: The script draws an island and a turtle underneath. Requires any 10.2 version.

And here is a bonus script from Laurent (10.2.0.2).

Oh and by the way, Paul was kind enough to put Rob’s script on a t-shirt :)


Filed in Oracle on 02 Apr 08 | Tags: ,


Reader's Comments

  1. |

    [...] that the Obfuscated SQL Code Contest arose. Eddie Awad played Master of Ceremonies, and here announces the winners or the contest (everyone!), writing, “The SQL code that was submitted was not only obfuscated but also beautiful and [...]