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
Java Programming
Print PageOracle Database 10g: Program with PL/SQL - Level 1
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.
View other Oracle Courses available
View other Oracle Courses available
- 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:
Oracle Database 10g: Introduction To SQL – Complete Library
LANGUAGE FEATURES:
Understanding PL/SQL
Structure of a PL/SQL Program Block
PL/SQL from Interactive Tools
Geberating Output within SQL *Plus
Structure of a PL/SQL Program Block
PL/SQL from Interactive Tools
Geberating Output within SQL *Plus
DECLARE CLAUSE:
About the Declare Clause
Declare Simple Types
Complex Types
Type ... Table
Type ... Record
Declare Simple Types
Complex Types
Type ... Table
Type ... Record
BEGIN CLAUSE:
About the Begin Clause
Performing Data Manipulation
Logic Control & Branching
If-Then-Else
Case
Performing Data Manipulation
Logic Control & Branching
If-Then-Else
Case
EXCEPTION CLAUSE:
About the Exception Clause
Isolating the specific Exeption
Pragma Exception_INIT
SQL%Rowcount & Select ... INTO
Isolating the specific Exeption
Pragma Exception_INIT
SQL%Rowcount & Select ... INTO
EXPLICIT CURSORS:
About Explicit Cursors
Advanced Curser Techniques
Advanced Curser Techniques
ADVANCED PROGRAMMING: NESTED BLOCKS:
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS: