PL/SQL
- Introduction to PL/SQL
- Advantages of PL/SQL
- The PL/SQL Block
- Basic PL/SQL Block Structure
- The Declaration Section
- The Execution Section
- The Exception Section
- Generation Output
Variables And Constants
- Data types
- Scalar Data types
- Composite Data types
- Variables (%type, %rowtype)
- Variable Assignment
- Scope of Variables
- Constants
- Writing Sample programs demonstrating all above Functionalities
Conditions and Loops
- Conditional Control
- Iterative Control
- Guidelines
- Sample, While, and For Loops
- While Loop
- For Loop
Cursors
- Implicit and Explicit Cursors
- Cursors Actions
- Declaring a Cursors
- Opening a Cursors
- Fetching Data from ad Cursor
- Closing a Cursor
- Cursor Attributes
- Cursors and Loops
- Cursors For Loops
Exception Handling
- Guidelines
- Types of Exceptions
- Named System Exceptions
- Named User-Defined Exceptions
- Unnamed System Exceptions
- Unnamed User-Defined Exceptions
- SQL ERRM and SQL Code
Procedures
- Writing Procedures using Oracle SQL,PLSQL
- Types of Program Units
- Named and Unnamed Block Structures
- Diff between Anonymous Blocks and named Blocks
- Procedures Parameters
- Parameter Modes
- IN
- Out
- IN Out
- Testing Procedure from anonymous blocks
- Calling procedure from another procedure
User Defined Functions
- Using Functions within Oracle
- Difference ways of Callings a function
- Named Notation
- Functions
- Function Parameters
- Referencing a Function
Packages
- Defining and Using Packages
- Advantages of Using Packages
- Overloading
- Dependency
- Abstraction – Information Hiding
- Inheritance
- Defining Global Variables
Database Triggers
- Trigger Types
- Trigger Events
- Trigger Restrictions
- Trigger Body
- Complication of Database Triggers
- Trigger Syntax
- Usage of Instead of Triggers
An Overview of Oracle Large Objects
- BLOB
- CLOB
- PL/SQL Table
- VARRAY
- BFILE
- Nested Tables
