PL/SQL (Procedural Language/Structured Query Language) is a database oriented programming language that extends Oracle SQL with procedural capabilities. This language offers far more execution potential than simple updates, selects, inserts, and deletes. It also offers a procedural extension that allows for modularity, declaration of variables, loops and other logic constructs and error handling.
Training Objectives of PL/SQL :
Oracle 10g PL/SQL students will able to write stored procedures, functions, packages and triggers and implement complex business rules in Oracle. Students will also learn programming concepts, management and security issues of working with PL/SQL program units. Programming topics will include the creation of triggers and stored procedure features.
Target Students / Prerequisites :
Students must have sound Technical Knowledge and Logical Skills.