The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed.
-Exploiting and managing cursor sharing.
-Utilizing cursor variables.
-Invoking external procedures.
-Including dynamic SQL and other advanced programming techniques.
-Efficiently executing dynamic SQL using bulk bind techniques.
-Tuning with the DBMS_PROFILER() system-supplied package.
-Debugging with the DBMS_TRACE() system-supplied package.
-Performance tuning and analysis of PL/SQL applications.