No1 Oracle PL/SQL Online training in Hyderabad

Sponsored Ads

Price: 300.00 Dollar US$

SADGURU TECHNOLOGIES - 8179736190 04040154733 www.sadgurutechnologies.com PL-SQL (Procedure Language – SQL)• ...

  • Category: Language Classes
  • Published: 01/10/2015
  • Current Rating: /5 0 Vote

    Description

    SADGURU TECHNOLOGIES - 8179736190 04040154733 www.sadgurutechnologies.com 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 PACKAGE EXCEPTIONS in PL/SQL • Types of exceptions • User Defined Exceptions,Pre Defined Exceptions • RAISE_APPLICATION_ERROR • PRAGMA_AUTONOMOUS_TRANSACTION • SQL Error Code Values Database 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: sdtech.soa@gmail.com


    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:


    www.sadgurutechnologies.com


    Phone Number : 8179736190

    Related Ads

    Leave your comment


    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com