PL/SQL Syllabus

PL/SQL

1.        Introductions

Introduction, Advantages, Basic Syntax, First Program, Writing & Executing

2.        Basic elements of PL/SQL

Character Set, Identifiers, Delimiters, Data types, Constants, Variable, Operators

3.        Statements

Simple, Control (if), Looping (for, while), Jump (exit, goto, continue)

4.        Exception Handling

Handling an exception, User-defined Exception, Pre-defined Exception

5.        Cursors & Records

Implicit & Explicit Cursors, Table- Based, Cursor-Based and User-defined Records

6.        Procedures

Creating, Executing, Deleting, Parameter Modes

7.        Functions

Creating, Calling, Recursive

8.        Triggers

Benefits, Creating, Triggering