iNEWPM
Course Duration:1 Month

Course Details

Oracle 11g: PL/SQL

Topics

1.      PL/SQL Structure

·         Variables

·         Data type

2.      Creating the Executable Section

·         Comments6

·         Literals

·         Operator

·         Output Statement

·         Accepting input from user

·         Variable scope

·         Function

·         Programs using SQL Statements in PL/SQL

3.      Writing Control Structures

·         If statement in PL/SQL

·         If...else statement in PL/SQL

·         Else if ladder statement in PL/SQL

·         LOOPs in PL/SQL

4.      Working with Composite Data Types

·         PL/SQL Records

·         Collections

5.      Cursors

·         PL/SQL Attributes  Cursor Attributes

·         Using cursor with for …loop

6.      Exception Handling

·         What is an Exception?

·         How to handle Exception?

·         Predefined Exception

·         Get information about error with –SQLCODE and SQLERRM

·         Non Predefined Error

·         User Defined Exception

7.      Stored Procedures

·         Advantages of procedures

·         Creating procedure

·         Formal and actual parameters in procedure

·         Using Anonymous block to invoke a procedure

·         Default option for parameters

·         Using Sub Procedures

·         Calling procedure from another procedure

·         Handled and Unhandled Exception when procedure called

·         Delete procedure

8.      Functions

·         Advantages of Functions

·         Calling function in SQL statement

·         Restriction on calling function in SQL statement

·         Deleting a Function

·         Difference between function and procedure

9.      Packages

·         Advantages of packages

·         Package Structure

·         Executing the procedure and function

·         Removing package

10.  Triggers

·         Creating a trigger

·         Accessing a column using row trigger

·         Using Statement trigger

·         Modifying a Trigger

·         Enabling and Disabling a trigger

·         Dropping a trigger

11.  Oracle Architecture- Complimentary Session

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
Post Your Training / Course Enquiry
Are you looking Institutes / Coaching center for
  • IT Courses
  • Govt Exam Preparation
  • Higher Studies in India
  • Studies Abroad
Select your Training / Study Category
Please select atleast one Query.Minimum 10 characters required
NEWFreeCompanies HiringUpdates//nuPM