Online Database Using Pl eLearning Training
From 123-CBT Computer Based Training
SQL and PL SQL PL SQL Basics

Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
From Teach Me IT
Advanced PL/SQL Programming

...variables using collections
Implement varrays
Integrate database using PL/SQL triggers
Apply database triggers
Manipulate data using cursors
Declare a cursor variable
Integrate transactions with database
Restrict database access by applying locks
Control user access
Define dynamic SQL
Use DBMS_SQL to execute non-query DDL and DML statements
Use the DBMS_SQL package to execute queries
more...
