« 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.