Batch Date: April 21st @ 11:00AM Faculty: Mr. Krishna Reddy Duration: 20 days Fee: 500 INR Venue : Canara bank building 2nd floor, near S. R Nagar Ploce Station, Hyderabad-500038. Contact no: 80 96 96 96 96.
Batch Date: April 21st @ 11:00AM Faculty: Mr. Krishna Reddy Duration: 20 days 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
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 :
Packages :
Collections in PL/SQL Built-in packages in PL/SQL Oracle 10g features Oracle 11g features DBA concepts
Introduction
to PL/SQL