Introduction to Oracle9i: PL/SQL Language

Request more details:

submit request
Description:
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. At Course Completion The primary objective of this course is to provide an introduction to the PL/SQL database programming language. Major subject areas to be explored are: �� Declaring variables and complex datatypes. �� Developing logic within PL/SQL program blocks. �� Fetching data from the database into program variables. �� Returning program output to users. �� Handling program exceptions. �� Using explicit and implicit database cursors. �� Using the advanced features of nested blocks and subprograms.

View other Oracle Courses available

Prerequisites:
Mandatory Prerequisites: Introduction to Oracle9i: SQL and Introduction to Oracle9i: Advanced SQL
LANGUAGE FEATURES:
�� why use pl/sql?
�� where pl/sql program units may be deployed
�� the java alternative to pl/sql
�� structure of a pl/sql program block
�� pl/sql from interactive tools
�� generating output
DECLARE CLAUSE:
�� datatypes
�� declare example
�� special datatypes
�� %type variable
�� %rowtype record
�� type table
BEGIN CLAUSE:
�� data manipulation
�� char and varchar
�� numeric
�� date
�� boolean
�� comparison operators
�� functions
�� date calculations
�� selectinto
�� logic control & branching
�� goto
�� loop
�� if-then-else
�� case
EXCEPTION:
�� handling exception
�� special features
�� system defined exceptions
�� using sqlcode & sqlerrm
�� implicit cursors
�� user-defined ex_ined
�� pragma exception_init
EXPLICIT CURSORS:
�� understanding cursors
�� explaining the cursor example
�� declare cursor e
�� open cursor example
�� fetch cursor example
�� close cursor example
�� including cursor parameters
�� performing updates from cursors
�� using forloop cursors
ADVANCED:
�� using nested blocks
�� using declared subprograms
�� display_message() procedure example
�� get_spouse_name() function example