Price: 300.00 US$

Sponsored Ads

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

More Details

Total Views:4
Reference Id:#717814
Phone Number: 8179736190
Website URL: Click To Visit
Current Rating: /5 0 Vote
Copyright © 2017 |   All Rights Reserved |   TuffClassified |   24x7 support |   Email us: query[at]tuffclassified.com