This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Alex Nuijten

SQL Syntax: Oracle vs. ANSI. Fight!


Alex Nuijten, allAPEX & Chris Saxon, Oracle


 

Abstract

Debates over whether it is better to use Oracle syntax or ANSI in your SQL rage on the internet. 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.

Speaker Biography

Alex Nuijten is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX) and member of the Smart4APEX Guild.Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards.He wrote 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). Alex is co-author of the following books “Oracle APEX Best Practices” (published by Packt Publishers) and  “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.

Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL!To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at The Magic of SQL.If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask TOM.