Information Technology

Oracle PL/SQL Program Unit Development I

Participants gain detailed instruction in Oracle procedural code development. You learn to write PL/SQL procedures, functions, and packages in the Procedure Builder and the SQL*Plus environment. Cover creating database triggers, cursors, loops, stored program units, and exception handling. Participants use basic and enhanced features of Oracle as they create solutions during hands-on lab assignments.

    Topics Include:
  • Using variables
  • Procedural looping
  • Managing PL/SQL program constructs
  • Oracle exception handling
  • Explore Oracle supplied packages
  • Troubleshooting techniques
  • Create, execute, and maintain procedures, functions, packages, and database triggers

Oracle Fundamentals or equivalent experience.

Available Sessions
Course not available for public enrollment at this time.
To schedule for your organization, contact Customized Training