ORACLE PLSQL

Registration for : ORACLE PLSQL

Register Now

Share This Course

Data Types & Structures
pl/sql introduction
basics of pl/sql
datatypes & error handling
pl/sql wrapper utility
control structures
pl/sql records

Exception handling
Error checking & exception handling
Using the when others clause
Ensuring complete error checking
Passing error messages to calling routine
Understand Exceptions
Handle Exceptions with PL/SQL
Trap Predefined Oracle Server Errors
Trap Non-Predefined Oracle Server Errors
Trap User-Defined Exceptions
Propagate Exceptions
RAISE_APPLICATION_ERROR Procedure

Conditional Statements
conditional processing using if statements
conditional processing case statements
handle nulls to avoid common mistakes
build boolean conditions with logical operators
use iterative control with looping statements
constructing & identifying loop statements
block flow using loops and labels.

Procedures , Functions
basics of stored procedures.
basics of functions and packages.
defining stored procedures and functions.
functions & stored procedures prototypes.
passing arguments to functions & procedures.
Pinning packages in the SGA.
listing package information.
flexibility of cursors by using parameters.
procedures parameters and parameters modes.

Data Retrieval
Retrieving data.
Retrieve data using sql statements.

Cursors , Triggers
using cursor attributes
triggers & database events
define a trigger
timing a trigger
enabling & disabling a trigger
bulk queries
bulk dml
analyzing impact of bulk operations

Registration for : ORACLE PLSQL

Register Now

Share This Course