Oracle PL/SQL Training In Chennai

Vikapri course png
About PL/SQL

Oracle PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL Language designed to includes all SQL Statements in its Structure.

Oracle PL/SQL is a composition of Data Manipulating with SQL and Data Processing with Procedural Language.

We provide the best professional Oracle PL/SQL Training In Chennai, in which you get advanced training sessions and hands-on projects by Experts.

Course Contents - Oracle PL/SQL

Basics Of PL/SQL
  • PL/SQL architecture
  • PL/SQL and SQL*Plus
  • PL/SQL Basics, Variables, Constants, data types & error handling
  • PL/SQL wrapper utility
PL/SQL Structures
  • Simple blocks
  • Control structures
  • PL/SQL records
  • Recognizing the Basic PL/SQL Block and Its Sections
  • Describing the Significance of Variables in PL/SQL
  • Distinguishing Between PL/SQL and Non-PL/SQL Variables
  • Declaring Variables and Constants
  • Executing a PL/SQL Block

Error Checking – Exception Handling
  • Defining exceptions
  • Using the when others clause
  • Ensuring complete error checking
  • Passing error messages to calling routine

Boolean Logic In PL/SQL
  • Identifying the Uses and Types of Control Structures
  • Constructing an IF Statement
  • Constructing and Identifying Different Loop Statements
  • Controlling Block Flow Using Nested Loops and Labels
  • Using Logic Tables
  • If-then-else structure
  • Testing for numbers characters and Booleans

Cursors In PL/SQL
  • Cursor basics
  • Cursor basicsUsing a cursor for a multi-row SQL query

Iteration In PL/SQL
  • For loop
  • While loop

PL/SQL Tables
  • Defining PL/SQL tables
  • Reasons to use PL/SQL tables
  • Populating a PL/SQL table
  • Retrieving from a PL/SQL table

Dynamic SQL In PL/SQL
  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Nested Blocks In PL/SQL
  • Creating nested blocks
  • Understanding scope in nested blocks

Triggers In PL/SQL
  • Triggers and database events
  • Defining a trigger
  • Timing a trigger
  • Enabling and disabling a trigger

Stored Procedures, Functions And Packages
  • Basics of stored procedures
  • Basics of functions
  • Basics of packages
  • Defining stored procedures & functions
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Pinning packages in the SGA with dbms_shared_pool.keep
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information

Bulking In PL/SQL
  • Bulk queries
  • Bulk DML (forall statement)
  • Using cursor attributes
  • Analyzing impact of bulk operations