Course Introductory Video
UDEMY 101: How to Use Udemy? +Some Useful Tips
What is PL/SQL and Why to Use?
What is Pluggable Database?
The Sample (HR) Schema Used in This Course
Welcoming Gifts: Course Material & PL/SQL Cheatsheet
About the Database Installation
The Ways to Get a Database
Option 1: Installing VMware and VirtualBox on Windows
Option 1: How to Install the Virtual Box on Mac OS X?
Option 1: Downloading Virtual Machine Image(19c)
Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
Option 1: Configuring the VMware Virtualization Software
Option 1: Configuring the Oracle VirtualBox Virtualization Software
Option 1: Configuring SQL Developer inside of the Virtual Machine
Option 2: Downloading and Installing the Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using the SQL Developer
Option 2: Installing Sample Schemas in Oracle Database
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)
Option 3: Using Oracle Live SQL
Option 3: About Oracle Live SQL Restrictions
What are Variables and Why to Use Them?
Naming Rules & Naming Conventions
Declaring & Initializing & Using Variables - Part 1
Declaring & Initializing & Using Variables - Part 2
Declaring & Initializing & Using Variables (Code Samples)
Using %Type Attribute (Code Samples)
PL/SQL Delimiters and Commenting Your Code
PL/SQL Delimiters and Commenting (Code Samples)
PL SQL Variable Scope (Code Samples)
Using Bind Variables (Code Samples)
What are Control Structures & IF Statements
What are Control Structures & IF Statements (Code Samples)
Case Expressions (Code Samples)
What are Loops - Basic Loops
Basic Loops (Code Samples)
While Loops (Code Samples)
Nested Loops & Loop Labeling
Nested Loops & Loop Labeling (Code Samples)
Continue Statement (Code Samples)
GOTO Statement (Code Samples)
Quiz (Control Structures)
Operating with Selected Database Data..
Operating With Selected Queries (Code Samples)
DML Operations in PL/SQL (Code Samples)
Using Sequences in PL/SQL
Using Sequences in PL/SQL (Code Samples)
Extra - Enabling Server Outputs by Default
Quiz (Using SQL in PL/SQL)
Simple Data Types vs Composite Data Types
PL/SQL Records (Code Samples)
Easy DML With Records (Code Samples)
Varrays & Collection Methods
Nested Tables (Code Samples)
PL&SQL Associative Arrays (Part 1)
PL&SQL Associative Arrays (Part 2)
Associative Arrays (Code Samples)
Storing Collections in Tables - (Part 1)
Storing Collections in Tables - (Part 2)
Storing Collections in Tables (Code Samples)
Quiz (Composite Data Types)
What are Cursors and Cursor Types in PL SQL?
Using Explicit Cursors (Code Samples)
Using Cursors with Records
Cursors with Records (Code Samples)
Looping with Cursors (Code Samples)
PL SQL Cursors with Parameters
PL SQL Cursors with Parameters (Code Samples)
PL SQL Cursor Attributes (Code Samples)
For Update Clause (Code Samples)
Where Current Of Clause (Code Samples)
Reference Cursors - (Code Samples)
What are the Exceptions (Code Sample)
Handling the Exceptions (Code Samples)
Handling the Nonpredefined Exceptions
Handling Nonpredefined Exceptions (Code Sample)
Handling & Raising User-Defined Exceptions
Handling & Raising User-Defined Exceptions (Code Samples)
Using RAISE_APPLICATION_ERROR() Procedure
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
What are Functions & Procedures and Why We Use?
What are Functions & Procedures and Why We Use (Code Samples)
Creating and Using Stored Procedures
Creating and Using Stored Procedures (Code Samples)
Using IN & OUT Parameters
Using IN & OUT Parameters (Code Samples)
Named & Mixed Notations and Default Option
Named & Mixed Notations and Default Option (Code Samples)
Creating and Using Functions (Part 1)
Creating and Using Functions (Part 2)
Creating and Using PL/SQL Functions (Code Samples)
Local Subprograms (Code Samples)
Overloading the Subprograms
Overloading the Subprograms (Code Samples)
Handling the Exceptions in Subprograms
Handling the Exceptions in Subprograms (Code Samples)
Finding & Removing the Subprograms
Regular & Pipelined Table Functions
Regular & Pipelined Table Functions (Code Samples)
Quiz (PL/SQL Functions & Procedures)
Creating & Using & Modifying & Removing the Packages
Creating & Using & Modifying & Removing the Packages (Code Samples)
Visibility of Package Objects
Visibility of Package Objects (Code Samples)
Illegal Object Reference & Forward Declaration
Persistent State of Packages - Part 1
Persistent State of Packages - Part 2
Persistent State of Packages (Code Samples)
Using Collections in PL/SQL Packages - Part 1
Using Collections in PL/SQL Packages - Part 2
Using Collections in PL/SQL Packages (Code Samples)
How Can I Find the Packages?
What are Triggers & Trigger Types
Understanding DML Triggers
Specifying the Timing of Triggers
Specifying the Timing of Triggers (Code Samples)
Statement & Row Level Triggers
Statement & Row Level Triggers (Code Samples)
Using New & Old Qualifiers in Triggers
Using New & Old Qualifiers in Triggers (Code Samples)
Using Conditional Predicates
Using Conditional Predicates (Code Samples)
Using RAISE_APPLICATION_ERROR Procedure in Triggers
Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
Using Update Of Event in Triggers
Using Update Of Event in Triggers (Code Samples)
Using WHEN Clause in Triggers
Using When Clause in Triggers (Code Samples)
Instead of Triggers (Code Samples)
Exploring & Managing the Triggers
Creating Disabled Triggers
Creating Disabled Triggers (Code Samples)
Additional Real-World Examples for DML Triggers
Additional Real-World Examples for DML Triggers (Code Samples)
Compound Triggers (Code Samples)
Handling Mutating Table Errors
Handling Mutating Table Errors (Code Samples)
PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
Granting Debug Privileges to a User
PL/SQL Debugging: Debugging the Anonymous Blocks
Source Code: Debugging the Anonymous Blocks
Introduction to Dynamic SQL and Dynamic PL/SQL
Native Dynamic SQL PL/SQL
EXECUTE IMMEDIATE Statement
Execute Immediate Statement (Code Samples)
EXECUTE IMMEDIATE STATEMENT with the USING Clause
EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)
EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause
Execute Immediate with Bulk Collect (Code Samples)
Dynamic PL/SQL Blocks (Code Sample)
OPEN - FOR FETCH Statements
OPEN - FOR FETCH Statements (Code Sample)
Using the DMBS_SQL Package (The Method 4)
Using the DBMS_SQL Package (Code Samples)
What are Oracle Supplied Packages?
Using the DBMS_OUTPUT Package
Using the DBMS_OUTPUT Package (Code Samples)
Using the UTL_FILE Package (Part 1)
Using the UTL_FILE Package (Part 2)
Using the UTL_FILE Package (Part 3)
Using the UTL_FILE Package (Code Samples)
Using the UTL_MAIL Package (Part 1)
Using the UTL_MAIL Package (Part 2)
Using the UTL_MAIL Package (Code Samples)
Quiz (Oracle-Supplied Packages)
Managing Security for Definer's Rights and Invoker's Rights (Part 1)
Managing Security for Definer's Rights and Invoker's Rights (Part 2)
Managing Security for Definer's Rights and Invoker's Rights (Code Samples)
Quiz (Miscellaneous Topics)
Appendix 1: Oracle Database 12c Installation into Your Computer
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c
How to Uninstall Oracle Database?