Session Number: 8219
Track: Application Express
Sub-Categorization: APEX Core
Session Type: Tips, Techniques and Tuning
Primary Presenter: Steven Feuerstein [Oracle Developer Advocate for PL/SQL - Oracle Corporation]
Time: Jun 25, 2019 (08:50 AM - 09:50 AM)
Room: 6C, Level 6
Speaker Bio: Steven Feuerstein is an expert in the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven is an architect for Oracle Corporation, leading a team of evangelists (a.k.a. advocates) with a mission of helping users leverage Oracle Database as a powerful application development platform. Steven has been developing software since 1980; he originally spent five years with Oracle (1987-1992) and was PL/SQL evangelist for Quest Software (and then Dell) from January 2001 to February 2014, at which point he returned joyfully to Oracle Corporation. He was one of the original Oracle ACE Directors, and he writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He was also the first recipient of ODTUG's Lifetime Achievement Award in 2009. Read Steven's commentary on PL/SQL and other Oracle technologies at stevenfeuersteinonplsql.blogspot.com.
Technologies or Products Used: APEX,PL/SQL,SQL
Session Summary for Attendees: Ah, the joy of a low-code development tool like Application Express! You point, you click, and you get beautiful, powerful websites and mobile apps. But you will also almost certainly need to write some SQL and PL/SQL to complete the functionality of that application. Sadly, there is always a tendency when writing code within a point-and-click development environment to treat that code rather casually; after all, it is not the really important (user-facing) part of the application, right? Wrong! It’s all important, and it is way too easy to create an awful mess in your otherwise elegant APEX app if you treat your SQL and PL/SQL code as a “second-class citizen” in terms of the attention you give to it. Not to mention bad performance or maintenance nightmares! In this session, Steven will offer some recommendations for how best to write and manage your SQL and PL/SQL in your APEX applications, as well as cover key features in PL/SQL you should be leveraging.