Best Oracle PL/SQL Training

01/10/2015 Language Classes

Price: 300.00 US$

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

More Details

Total Views:8
Reference Id:#717750
Phone Number:8179736190
Website URL:Click To Visit
Current Rating: /5 0 Vote

Warning: mysqli::real_connect(): (HY000/2002): Connection refused in /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 115

Warning: mysqli::query(): invalid object or resource mysqli in /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 98

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on null in /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php:156 Stack trace: #0 /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php(134): SphinxQLClient->fetch(2, NULL, NULL) #1 /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQL.php(127): SphinxQLClient->fetchAll() #2 /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphSearch.php(547): SphinxQL->fetchAll() #3 /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/related-ads.php(121): SphSearch->doSearch() #4 /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/item.php(198): tfc_related_ads() #5 /mnt/volume-blr1-http/www/tuffclassified/oc-includes/osclass/helpers/hDefines.php(238): require('/mnt/volume-blr...') #6 /mnt/volume-blr1-http/www/tuffclassified/oc-includes/osclass/controll in /mnt/volume-blr1-http/www/tuffclassified/oc-content/themes/shopclass/includes/sphinx/SphinxQLClient.php on line 156