PL/SQL

Introduction to PL/SQL
Advantages of PL/SQL
PL/SQL architecture
Datatypes in PL/SQL
PL/SQL program structure
Simple PL/SQL programs
Embedding SQL statements in PL/SQL
Conditional statements
Loops
Cursors :

• About cursors in PL/SQL
• Explicit cursors
• For loop cursor
• Cursor paramenters
• For update clause
• Where current of clause
• Ref cursors
• Implicit cursors

Exception Handling :

• System defined exceptions
• User defined exceptions
• Sqlcode & sqlerrm
• Pragma exception_init

Subprograms :

• Introduction to subprograms
• Difference between anonymous & named blocks

Stored procedures :-

• Creatng procedures
• Working with IN , OUT ,INOUT parameters
• Procedures with cursors
• Procedures returning records
• Pragma autotnomous transaction

Functions :

• Difference b/w procedures and functions
• Inline functions

Packages :

• Introduction to packages
• Package specification and package body
• Overloading package members

Triggers :

• Introduction to triggers
• DML triggers
• DDL triggers
• Db auditing using triggers
• DB level triggers

Collections in PL/SQL
Built-in packages in PL/SQL
Oracle 10g features
Oracle 11g features
DBA concepts