-
Overview of PL/SQL
-
PL/SQL Language Fundamentals
-
PL/SQL Data types
-
Control Structures
-
PL/SQL Collections and Records
-
Using Static SQL
-
Using Dynamic SQL
-
PL/SQL Sub Programs
-
Overview of PL/SQL Subprograms
-
Subprogram Parts
-
Creating nested subprograms that invoke each other
-
Declaring and passing subprogram parameters
-
Overloading PL/SQL subprogram names
-
How PL/SQL subprogram calls are resolved
-
using recursive PL/SQL subprograms
-
invoking external subprograms
-
understanding PL/SQL subprogram parameter aliasing
-
Overview of PL/SQL Subprograms
-
Using Triggers
-
Using PL/SQL packages
-
Handling PL/SQL Errors
Using Cursor Variables(REF Cursors)
The lesson content is empty.