Oracle Database 10g: Program with PL/SQL - Level 1
Course 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
2 days
Contact us for pricing
Prerequisites
Oracle Database 10g: Introduction To SQL – Complete LibraryLANGUAGE FEATURES
Understanding PL/SQLStructure of a PL/SQL Program Block
PL/SQL from Interactive Tools
Geberating Output within SQL *Plus
DECLARE CLAUSE
About the Declare ClauseDeclare Simple Types
Complex Types
Type ... Table
Type ... Record
BEGIN CLAUSE
About the Begin ClausePerforming Data Manipulation
Logic Control & Branching
If-Then-Else
Case
EXCEPTION CLAUSE
About the Exception ClauseIsolating the specific Exeption
Pragma Exception_INIT
SQL%Rowcount & Select ... INTO
EXPLICIT CURSORS
About Explicit CursorsAdvanced Curser Techniques
ADVANCED PROGRAMMING: NESTED BLOCKS
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS
ISTQB Advanced Test AnalystOracleOracle 10gOracle Database 10g