Introduction
- Introduction
Preparing Your Environment
- Course Setup
Working with Oracle Database Tools
- Selecting the Appropriate Database Tool
Language Features
- Understanding PL/SQL
- PL/SQL Blocks
- Working with SQL Plus
The DECLARE Clause
- DECLARE Clause Objects
- PL/SQL Available Data Types
- Declaring Simple Data Types and Assignments
- Declaring Complex Data Types and Assignments
- Declaring Complex RowTypes and Assignments
- Declaring Complex Tables
- Declaring Complex Records
- Creating and Declaring User-Defined Types
The BEGIN Clause
- What Can Be Included in the BEGIN Clause
- Working with CHAR and VARCHAR2 Variables
- Handling String Literals
- Working with Numeric Variables
- Working with Date Variables
- Assigning and Using Boolean Variables
- Using Comparison Operators
- Using SQL Functions
- SQL DML within PL/SQL
- Using SELECT
- Exceptions and Embedded SQL
- Using Sequences
- Logic Control and Branching
- Using GOTO
- Working with LOOPS
- Creating and Using the Indefinite Loop
- Creating and Using the Conditional Loop
- Using Nested Loops
- Using the If-Then-Else
- Using the CASE Statement
The EXCEPTION Clause
- What Are the Types of Exceptions
- Trapping Exceptions
- Identify Exception Details
- Creating User-Defined Exceptions
- Using SQLCODE and SQLERRM Objects
- Understand the Implicit Cursor
- Creating User-Defined Events
Explicit Cursors
- Understanding the Concept and Purpose of Explicit Cursors
- Learn about Cursor Attributes
- Using the Continue Statement
- Working with Updateable Cursors
- Creating and Using Cursor Parameters
- FOR...LOOP Cursors
Nested Blocks
- Understanding Nested Blocks
- Difference between Global vs Local Objects and Exceptions
Declared Subprograms
- Subprograms: How They Differ from Nested Blocks
Conclusion
- Conclusion
