Central Institute of Information Technology ^®
Plot No.2, Near Jerryl Lawns, RPTS Road, Opp. Momentum Classes, Laxminagar, Nagpur - 440022
Email: ciit_nagpur@yahoo.com Mobile: 9011501192

Join Pl/Sql Classes in Nagpur at CiiT

Oracle Pl/Sql Course - Learn PL/SQL from basic to an expert level

Job-Oriented Course with Comprehensive Syllabus at an Affordable Fee - 100% Placement Assistance

PL/SQL is mixture of SQL statements with procedural constructs/language. Pl/Sql is used in software development by programmers to build/impliment business logic. Without PL/SQL, Oracle can execute single SQL statements at a time. Pl/Sql programs can be compiled once and stored in executable form to improve execution/response time. Pl/Sql programs reduces network traffic between the app/client and the database. Pl/Sql programs are very secure. PlSql support Object-Oriented Programming. PL/SQL supports both static and dynamic SQL. Learning PL/SQL can significantly boost your career in IT industry.

PL/SQL Course PreRequisite : This course is designed such that anyone or beginners willing to learn PL/SQL can take it. But Sql Knowledge is must. So first step is to learn SQL and then proceed to Pl/Sql.

PL/SQL Course Duration : 20 Days Sql Course

Oracle PL/SQL (Procedural Language extensions to SQL) Syllabus

Introduction TO PLSQL

PLSQL block Structure/Architecture

Data Types

Declaring Variables(Assignment, Default, Not Null, %Type, %Rowtype, Aggregate, Aliases, Scope)

Datatype Conversion (Implicit and Explicit)

Control Structures

Conditional Control Statements
If ...Then
If ...Then ...Else
If ...Then ...ElsIf

Iterative Statements
For(...Range...)Loop .. End Loop
While(...condition...)Loop ... End Loop
Loop ... End Loop --Explicite Exit Statement

Exit Statement

GoTo Statement

Null Statement

Into Statement

Implicit Cursors (Dml/Select Into)

Attributes(SQL%Found, SQL%NotFound, SQL%RowCounts, SQL%IsOpen)

Explicit Cursors

Declare,Open,Fetch,Close,Use with For,While,Loop Iterative Statements

Parameter passing,Attributes(C%Found,C%NotFound,C%RowCounts,C%IsOpen)

Value of attributes at different conditions.

Reference Cursor / Cursor Variables

Row Locking : For Update (/NoWait/Of ColumnName) Clause

Table Locking:Lock Table

Dynamic DDL statement in PLSQL using DBMS_SQL Oracle Package.

Exceptions Handling

Sub-Programs (Procedures and Functions)

Stored Programs (Procedures and Functions)

Database Triggers

Collections

Records

Object Types

Stored Procedures

Stored Functions

Packages

Oracle Supplied Packages

Manipulating Large Objects

Database triggers : Statement Level and Row Level triggers

Managing Dependencies

Basic PL/SQL Syntax :

    Declare 
       --declarations section
    Begin 
       --executable commands
    Exception
       --exception handling
    End;
    
    eg.
    Declare 
       var varchar(15);
    Begin 
       var := 'Hello World!';
        Dbms_Output.Put_Line( var );
    Exception
       When Others  Then
        Dbms_Output.Put_Line( 'Default Exception Handled' );
    End;