Dealing with Variables
- PL/SQL Block Structure
- PL/SQL Blocks and types
- Program Constructs
- Use of Variables
- Handling Variables in PL/SQL
- Types of Variables
- Declaring PL/SQL Variables
- The %TYPE Attribute
Building Blocks of Executable Statements
- Building Blocks of Executable Statements
- PL/SQL Block Syntax and Guidelines
- Identifiers and comments
- Usage of SQL Functions in PL/SQL
- Data Types and Conversions
- Nested Blocks and Variable Scope
- Operators in PL/SQL
Basic SQL statements' usage in PL/SQL
- Data retrieval in PL/SQL
- SQL Cursor and its attributes
- DML statements in PL/SQL
- TCL statements in PL/SQL
Control Structures
- IF statements
- Case expressions
- While Loops
- FOR loops
- Nested Loops
Composite Datatypes (Collections and Records)
- PL/SQL Records
- %ROWTYPE attribute
- INDEX by Tables
- VARRAY
Everything about Explicit Cursors
Exceptions
- Handling Exceptions with PL/SQL
- Exception Types
- Catching Exceptions
- Predefined Exceptions
- User-Defined Exceptions
- RAISE_APPLICATION_ERROR Procedure