PLSQL on 3 March (Monday) 5:00PM by Mr. Krishna Reddy @ S.R Nagar Hyderabad

Batch Date: March 3rd @ 5:00PM Faculty: Mr. Krishna Reddy Duration: 20 days (Daily One and half Hour)     Fee:  500 INR Venue : Canara bank building 2nd floor, near S. R Nagar Ploce Station, Hyderabad-500038. Contact no: 80 96 96 96 96.

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 Check for more info............http://www.durgasoft.com/PLSQL-KrishnaReddy.asp