Start Date : 9-JUL-2014 03:00:00 PM GMT
End Date : 9-JUL-2014 07:00:00 PM GMT
Oracle PL/SQL makes writing SQL so darned easy – in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code. This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names. After attending this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability.
PL/SQL webcasts offer one and two-hour presentations on features of and best practices for PL/SQL programming.
All PL/SQL webcasts are free.
One or two hours in duration
Some familiarity with the PL/SQL language will be helpful, but not necessary.