SQL Syntax: Oracle vs. ANSI—Fight!

Session Number: 8160
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Alex Nuijten [Director - allAPEX]
Co-Presenter: Connor McDonald [Developer Advocate - Oracle]
Time: Jun 25, 2019 (03:45 PM - 04:45 PM)
Room: 616, Level 6

Speaker Bio: Alex Nuijten is an independent consultant (allAPEX) specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Alongside his consultancy work, Alex conducts training classes, mainly in APEX, SQL, and PL/SQL. Alex has been a speaker at numerous international conferences such as ODTUG Kscope, Oracle OpenWorld, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World, and OBUG. For his presentations, Alex has received several best speaker awards.

Alex has written many articles in Oracle-related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog Notes on Oracle (nuijten.blogspot.com). He is co-author of the book Oracle APEX Best Practices (published by Packt Publishers). Alex is also co-author of Real-World SQL and PL/SQL (published by Oracle Press).
Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.

Technologies or Products Used: SQL,PL/SQL

Session Summary for Attendees:  Debates rage on the internet over whether it is better to use Oracle syntax or ANSI in your SQL. It is time to settle these once and for all! In the blue corner, Alex will champion ANSI style. And in the red corner, Chris will defend Oracle syntax.

In a best-of-three battle covering joins, functions, and recursive queries, they will each highlight the benefits of their chosen style.
This session is for developers looking to expand their SQL skills and understand the pros and cons of the syntax methods.