|
|
O9i-DPUDevelopment of program units on PL/SQL in Oracle9i
Subject of course are stored program database objects - stored procedures, functions, packages and triggers of a database. Students also learn about possibilities of some standard delivered Oracle packages and will seize receptions of processing of the big objects.
Upon termination of course students will learn:
- to use possibilities PL/SQL;
- to create and use procedures;
- to create, use, call and delete functions;
- to accompany with subroutines;
- to create and control packages and their components;
- to control restarted batch components;
- to use dynamically executable SQL commands and various packages of server Oracle;
- to accompany with big objects (LOB);
- to accompany with dependences. Necessary preparation Is recommended to hear courses: O9i-SQL; O9i-PLSQL or to possess equivalent knowledge.
Education coast on cource - USD 450
Cource duration (days) - 3
|
|
