Oracle PL/SQL Best Practices For Beginners


08 Feb 2016

Over its lifetime, PL/SQL has grown increasingly robust and complex. Many programmers are barely aware of the new capabilities of PL/SQL, much less fully understand the implications for their programs. And virtually all PL/SQL developers are too pressured by deadlines to have the time to think through the best way to apply PL/SQL’s many features.

Oracle10g might let the DBAs off the hook with automated management, but developers still have our work cut out for us. Fortunately, Oracle offers some most excellent new toys for PL/SQL programmers and DBAs, including powerful set operations on nested tables, a job scheduler you can actually come to love, and an optimizing compiler. This presentation covers the most useful and interesting new features in Oracle10g PL/SQL.

The Best Practice PL/SQL one-day seminar will focus on N critical areas of development:

  • Writing SQL in PL/SQL: SQL statements lie at the heart of any PL/SQL application and PL/SQL makes it incredibly easy to write that SQL. This means that most of us take SQL totally for granted, which is a big mistake, since SQL statements are the slowest elements of our code and often need changing. Steven will show you how to take advantage of best features of PL/SQL for writing SQL and also offer best practices for writing SQL statements that can be more easily maintained and optimized.
  • Optimizing performance of PL/SQL applications: beyond SQL, there are many concerns and ways to improve the performance of one’s PL/SQL code. From new features to the careful application of long-standing features, Steven will show you how to analyze code performance and, at least in some cases, improve it by one or more orders of magnitude.
  • Unit testing PL/SQL programs: let’s face it, few of us test our code sufficiently. Who has the time? And how are you supposed to write that code, anyway? In this section of the course, Steven offers “six simple steps to unit testing happiness” that will utterly transform the quality and quantity of your PL/SQL testing.
  • Building modular, reusable code: just say “no”….to spaghetti code that is impossible to read, maintain, or enhance. In this section, Steven will show you how to take advantage of packages, local subprogram units, cursor variables, autonomous transactions, and more to craft small, reusable units of code.
  • Error management: every well-crafted application follows a standard, consistent process for handling, raising and reporting errors. PL/SQL offers a powerful, flexible exception handling architecture, but it has its weaknesses. Steven will show you how to compensate for those weaknesses, take advantage of the latest error management features, and build a reusable package to log and raise exceptions.

Comments are closed.