Tony's Top 10 Oracle Tips and Tricks for Developers (394Kb) Presented at: Oracle Open World (OOW) Date: 09/23/2008 Abstract: Throughout the years, this session's speaker has accumulated a list of tips and techniques that assist with the development of Oracle Database-based custom applications. These tips and tricks can be used to improve application performance, streamline code, and create higher-quality applications. The speaker describes each topic in detail and provides real-world examples of how to use them.

New Oracle 10g & 9i Features For Developers (115KB) Presented at: Midwest Oracle Users Group (MOUG) Date: 09/08/2006 Abstract: This presentation covers the following: Internal PL/SQL Enhancements PL/SQL Compile Time Warnings DBMS_DDL DML Error Logging Merge Statement Flashback Query Flashback Table DBMS_METADATA Multi-Table Inserts Native Dynamic SQL Global Temporary Tables Bulk Binds with Collections

New 10g and 9i Features for Developers (369KB) Presented at: Collaborate Date: 04/26/2006 Abstract: As the new database versions roll out, so do some exciting new features. This presentation discusses the new Oracle 10g, Oracle9i and Oracle8i features that enhance the developer's ability to develop mission critical Web-based applications. Using the new features demonstrated in this presentation add reliability, stability, speed and flexibility to any application. Just a few of the topics featured in the presentation are: PL/SQL compilation, Merge, multi-table inserts, bulk binds, triggers on system events, and Native Dynamic SQL. Attendees gain an understanding of the features; learn when to use them and learn the design considerations associated with each.