Who will the Course Benefit? Who will the Course Benefit?
Oracle database administrators and software development personnel who need to write new or maintain existing, PL/SQL triggers, program units and packages.
Practical experience of Oracle SQL and of using SQL*Plus or SQL Developer and a good working knowledge of the fundamentals of the Oracle PL/SQL programming language are required.
The delegate will learn and acquire skills as follows:
Implementing various types of trigger
Creating, managing and invoking stored procedures
Creating, managing and executing stored functions
Developing and using packages
Using package features and constructs effectively
Using Cursor Variables
Using records and tables or associative arrays in packages
Implementing Bulk Binding and Bulk Collecting techniques
Managing program unit dependencies
Implementing Native Compilation and Compile-time Warnings
Implementing Native Dynamic SQL
Using a variety of Oracle-supplied packages
Using a variety of Oracle-supplied packages Course Objectives Course Objectives
To provide the skills needed to develop, write and maintain triggers, stored program units and packages.
Practical experience of Oracle SQL*Plus or SQL Developer and a good working knowledge of the fundamentals of the Oracle PL/SQL programming language is required. This can be gained by attendance on the pre-requisite courses.
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.