Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageUsing Oracle PL/SQL
Description:
- Cost: Price on application
- Duration: 2 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Programming skills are assumed and some knowledge of Oracle and SQL.
Introduction:
The purpose of PL/SQL
Block structures and flow control
IF and LOOP statement
General comments on PL/SQL
Advantages of using PL/SQL
Block structures and flow control
IF and LOOP statement
General comments on PL/SQL
Advantages of using PL/SQL
Variables and Constants:
Declaring variables
Declaring constants
Using variables
Variable scope
Declaring constants
Using variables
Variable scope
Cursor and Multi-flow SELECT Statements:
Declaring and using cursors
Implicit cursors
Implicit cursors
Composite Datatypes:
Tables
Records
Records
Exception Handling:
Predefined exceptions
User defined exceptions
SQLCODE and SQLERRM
User defined exceptions
SQLCODE and SQLERRM
Stored Procedures and Functions:
Stored procedures and functions
Creating SQL accessible functions
Testing procedures
Creating SQL accessible functions
Testing procedures
Packages:
The customer maintenance package
Using packages
Dependencies
Wrapped PL/SQL
Supplied packages
Using packages
Dependencies
Wrapped PL/SQL
Supplied packages
Triggers:
An UPDATE trigger
Triggering statement
Trigger restriction
Trigger action
Creating, enabling, and disablilng triggers
Compiling triggers
Triggering statement
Trigger restriction
Trigger action
Creating, enabling, and disablilng triggers
Compiling triggers