Oracle PL/SQL Training

Duration: 3 days

Audience: Application developers and database administrators

Prerequisites: solid understanding of SQL

Course contents:

• Triggers
• PL/SQL variables and data types
• PL/SQL syntax and logic
• Stored functions and procedures
• Exception handling
• Records and collections
• Cursors
• Using packages
• Creating packages
• Working with LOBs
• Maintaining PL/SQL code
• Dynamic SQL
• PL/SQL versions, data types, and language limits
• Oracle supplied packages