The Complete PLSQL Bootcamp (Beginners to Advanced)
Introduction
Installation
1
How to Install Oracle Database 19c In Windows
2
Enable Pluggable Database with TNSNAMES.ORA file
3
How To Create [TNS Service] Using Oracle Net Configuration Assistant
4
HOW TO UNLOCK HR AND SCOTT USER
5
Introduction to SQL PLUS
6
Introduction to SQL Developer with Installation
Declaring PLSQL Variables
1
Types of PLSQL blocks
2
DBMS_OUTPUT IN Oracle SQL Developer
3
Anonymous Block
5
Data Types & %TYPE Attribute
6
Declaring PLSQL Variables
7
Declaring PLSQL Constants
Writing Executable Statements
1
Writing Executable Statements
2
Learn to Comment the Code
3
Describe Nested Blocks
4
Identify the Operators in PLSQL
5
Indenting the Code
Writing Control Structures
1
IF STATEMENTS
2
CASE Statements
3
GO TO Statements
4
NULL Statements
Iterative processing with loops
1
Basic Loop
2
While Loop
3
For Loop
4
For Loop
5
Continue Statements
Using Cursors
1
Using Explicit Cursors
2
Cursor with parameters
3
PLSQL Records and Cursor
4
Cursor FOR Loops
5
Implicit Cursors
Creating Procedures
1
Creating Procedures
2
Parameter In Procedures
3
The %ROWTYPE Attribute
Handling Exceptions
1
Handling Exceptions
2
Handling Exceptions
3
Using Raise Application Error
Creating Procedures
1
Creating Procedures
2
Parameter In Procedures
3
The %ROWTYPE Attribute
Creating Functions
1
Creating Functions
Creating Packages
1
Creating and Using Packages
2
Creating and Using Packages
Creating Triggers
1
What is Trigger
2
What is Trigger
3
Creating Triggers with Raise Application Error
4
Disable, Enable and Drop Triggers
5
Disable, Enable and Drop Triggers
6
DML Triggers
7
DML Triggers
8
System Triggers
