Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to the PL/SQL Language
- Execution Environment
- Comparison of SQL and PL/SQL
- Language Characteristics and Lexical Units
- Structure of PL/SQL Blocks
- Anonymous Blocks versus Stored Subroutines
- Program Execution
Scalar Variables
- Declarations
- Data Types
- Lifetime, Scope, and Initialization
Controlling the Order of Instruction Execution
- Decision Making
- Loops
- Labels and Jumps
SQL Commands in PL/SQL
- DML Commands
- DDL Commands and Dynamic SQL
- TCL Commands and Transaction Management
- Simplified SELECT Command
Cursor Handling
- Record Types
- Static Cursors
- Cursor Loops
- Cursor Parameterization
Error and Exception Handling
- Names, Codes, and Messages
- Exception Handling Sections and Propagation
- Defining and Utilising Custom Exceptions
- Simulating Error Occurrences
- Application Errors
Recommended Pre-training:
ORA_S1
Recommended Follow-up Training:
ORA_P2
Requirements
Participants should possess knowledge of fundamental database concepts and SQL basics, including queries, as well as DML, DDL, and TCL commands. Basic programming skills in any structured language are advantageous.
14 Hours
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Course - ORACLE PL/SQL Fundamentals
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
