Download Now! (131 KB, Updated: June 24, 2006)
No doubt about it: PL/SQL is the best place to write SQL when you need to access the Oracle database. No need for JDBC, ODBC or any of that other nonsense! Just write your SQL and off you go...but wait, it gets even better! Over the past several versions, Oracle has added SQL-centric functionality to PL/SQL to make it easier to write and faster to run SQL from within PL/SQL programs.
This one-hour presentation will make sure you know about all the things you can do to take maximum advantage of SQL inside PL/SQL, from BULK COLLECT and FORALL to table functions, with a visit into the world of record-level DML.
You should have a working knowledge of PL/SQL and at least a year's worth of experience with the language. All developers, from beginner to expert, will benefit from Steven's ideas and examples.
Steven will demonstrate techniques and principles that apply to all versions of Oracle, but will also showcase new features in Oracle Database 10g that can dramatically improve the quality and performance of code that you write.
This download contains the following file:
- Hands-on collections.ppt - A Powerpoint presentation