Gain knowledge of advanced features of PL/SQL programming including Oracle collections and complex aspects of control structures. Cover advanced cursor and dynamic PL/SQL use techniques. Explore handling obfuscating code and controlling access to underlying objects and scheduling recurring jobs using the special Oracle utilities techniques. Discover how to apply advanced error handling capabilities of PL/SQL and advanced code tuning procedures. Hands-on labs reinforce the techniques and procedures discussed.
- Topics Include:
- Advanced techniques
- Looping structures and techniques
- CASE statements
- Referenced cursors & expressions
- Dynamic PL/SQL with bulk SQL
- The EXECUTE IMMEDIATE statement
- Oracle Scheduler and DBMS Job
Oracle PL/SQL Program Unit Development I Oracle PL/SQL Program Unit Development I or equivalent experience.