Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Oracle 11g PL/SQL Part 1
Introduction
Introduction (3:06)
Preparing Your Environment
Course Setup (37:03)
Working with Oracle Database Tools
Selecting the Appropriate Database Tool (30:45)
Language Features
Understanding PL SQL (17:59)
PL SQL Blocks (15:19)
Working with SQL Plus (11:00)
The DECLARE Clause
DECLARE Clause Objects (16:25)
PL SQL Available Data Types (16:55)
Declaring Simple Data Types and Assignments (12:16)
Declaring Complex Data Types and Assignments (10:38)
Declaring Complex RowTypes and Assignments (7:02)
Declaring Complex Tables (7:44)
Declaring Complex Records (8:12)
Creating and Declaring User-Defined Types (8:48)
The BEGIN Clause
What Can Be Included in the BEGIN Clause (7:02)
Working with CHAR and VARCHAR2 Variables (7:30)
Handling String Literals (7:41)
Working with Numeric Variables (6:40)
Working with Date Variables (6:00)
Assigning and Using Boolean Variables (7:44)
Using Comparison Operators (7:24)
Using SQL Functions (6:04)
SQL DML within PL SQL (15:05)
Using SELECT (6:32)
Exceptions and Embedded SQL (11:16)
Using Sequences (14:28)
Logic Control and Branching (6:58)
Using GOTO (5:52)
Working with LOOPS (18:53)
Creating and Using the Indefinite Loop (6:59)
Creating and Using the Conditional Loop (8:48)
Using Nested Loops (11:33)
Using the If-Then-Else (18:54)
Using the CASE Statement (17:43)
The EXCEPTION Clause
What Are the Types of Exceptions (5:31)
Trapping Exceptions (5:32)
Identify Exception Details (10:57)
Creating User-Defined Exceptions (10:49)
Using SQLCODE and SQLERRM Objects (8:29)
Understand the Implicit Cursor (14:37)
Creating User-Defined Events (12:26)
Explicit Cursors
Understanding the Concept and Purpose of Explicit Cursors (18:10)
Learn about Cursor Attribute (10:12)
Using the Continue Statement (5:44)
Working with Updateable Cursors (19:25)
Creating and Using Cursor Parameters (14:45)
FOR...LOOP Cursors (6:53)
Nested Blocks
Understanding Nested Blocks (10:46)
Understanding the Difference between Global vs Local Objects and Exceptions (12:35)
Declared Subprograms
What Are Subprograms and How Are They Different from Nested Blocks (17:37)
Conclusion
Course Recap (3:52)
Understanding the Difference between Global vs Local Objects and Exceptions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock