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