UK Oracle User Group

SQL Magic: Tricks to Demonstrate SQL Features

« Return to event

Time: 2:15 PM - 3:00 PM

Track: Track 1

In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL "magic tricks" including:

  • Sawing the Query in Half: starting with a normal query, Chris will split it into smaller and smaller chunks  that somehow all give the same result!
  • Find the Card: After getting an audience member to choose a "card" (row) from a "deck" (table), Chris will find it by making it float to the top of the table.
  • The Magically Changing Data Type: watch as a number changes to a date and back again!

But unlike real magicians, he'll show you how the tricks work. This will enable you to perform your own "SQL magic” and build better Oracle database applications.

This session is for developers and DBAs looking to expand their SQL skills. It highlights features that are new to 12c as well as little used existing options.

Presented by

  • Chris Saxon, Oracle

Send this page to your friend

Your details

Your friend's details


Please click the box below to indicate you are a human rather than an automated system completing this form.