This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.
After the basic PL/SQL and SQL language skills, students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Student also learn to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects.
Students are introduced to the utilization of some of the Oracle-supplied packages.
This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Learn To:
- Declaring PL/SQL Variables
- Working with Composite Data Types
- Creating the Executable Section
- Using Explicit Cursors
- Writing Control Structures
- Including Exception Handling
- Create and manage Procedures and Functions
- Manage Dependencies and Large Objects
- Create Packages and maintain them
- Create and apply Triggers
- Utilizing Oracle-Supplied Packages in Application Development
- Understand and influence the PL/SQL Compiler