Oracle PL/SQL corporate training in India

01/10/2015 Language Classes

Price: 300.00 US$


SADGURU TECHNOLOGIES - 817973619004040154733 PL-SQL (Procedure Language – SQL) • Introduction to Programming Languages• Introduction & Advantages of PL/SQL • PL/SQL Architecture,PL/SQL Data types• Variable and Constants• Using Built-in Functions• Understanding control structure (Simple if, if… else, nested if..else, if..else Ladder)• Selection Case, Simple Case, GOTO Label and EXIT• Iterations in PL/SQL (Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS)• SQL within PL/SQL & Composite Data types • Cursors in Oracle • Implicit Cursors & Explicit Cursors• Cursor Attributes, Cursor with Parameters• Cursors with LOOPs Nested Cursors, Cursors with Sub Queries,Ref. Cursors• Record and PL/SQL Table Types Advanced PL/SQL• Procedures in PL/SQL• PROCEDURE with Parameters & Notations• Procedure with Cursors• Dropping a Procedure• Functions in PL/SQL• Difference between Procedures and Functions• User Defined Function & Nested Functions• Using stored function in SQL statements• Packages in PL/SQL• Creating PACKAGE Specification and PACKAGE Body• Private and Public Objects in PACKAGEEXCEPTIONS in PL/SQL • Types of exceptions • User Defined Exceptions,Pre Defined Exceptions• RAISE_APPLICATION_ERROR• PRAGMA_AUTONOMOUS_TRANSACTION• SQL Error Code ValuesDatabase Triggers in PL/SQL• Types of Triggers, Row Level Triggers, Statement Level Triggers• DDL Triggers, Trigger Auditing Contact us at: 08179736190, 040-40154733 Mail us at: SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, SaiManor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue,Mob: 40154733 , Email:

More Details

Total Views:6
Reference Id:#717920
Phone Number:8179736190
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]