 |
Oracle 10g Database Administration
COURSE OUTLINE:
Module 2: Program with PL/SQL
What is PL/SQL
- PL/SQL
Environment
- Benefits
of PL/SQL
- Stored
Procedures, Functions, and Triggers
- Stored Procedures and SQL Scripts
Structure of a PL/SQL Block
- Header
Section
- Declaration
Section
- Execution
Section
- Exception Section
Creating a PL/SQL Procedure
Creating a PL/SQL Function
PL/SQL Variables and Constants
- Declaring
PL/SQL Variables
- Declaring
PL/SQL Constants
- Assigning
Values to Variables
- Using Variables
Control Structures in PL/SQL
- IF Statement
- Loops
- Cursors
- Nested Loops
Error Handling
- Exceptions
- System
Defined Exceptions
- Programmer Defined Exceptions
Other PL/SQL Tools
- PL/SQL
Packages
- Triggers
- Views
used with PL/SQL
