PLSQL

PLSQL

PLSQL INTRODUCTION AND ARCHITECTURE ADVANTAGES OF PLSQL OVER SQL PLSQL ANOMALOUS VARIABLES DATATYPES, OPERATORS ERRORS IN PLSQL TYPES OF DECLARATIONS CONTROL STATEMENTS CURSORS & TYPES OF CURSORS Parameterized CURSORS EXCEPTIONS EXCEPTIONS & USER DEFINED EXCEPTIONS STORED PROCEDURE AND ITS ADVANTAGES PARAMETERS IN STORED PROCEDURES STORED FUNCTIONS & RESTRICTIONS PACKAGE AND ITS ADVANTAGES OVERLOADING AND RESTRICTIONS  TRIGGERS & TYPES OF TRIGGERS

     

•     PLSQL Introduction, DataTypes, Variables and Operators.

•     Anomalous PLSQL, Conditional Statements.
•     Cursors and Exceptions.
•     Procedures and Functions.
•     Packages and Triggers.
•     Local Sub Programs and Dependencies.