Introduction: PL/SQL Introduction

Note on the important definitions to remember  

Hands-On 01: PL/SQL Command line editing

L command - Lists SQL or PL/SQL from the SQL buffer

I command - Inserts SQL or PL/SQL lines

Del command - Deletes SQL or PL/SQL lines

C command - Changes SQL or PL/SQL lines

SAVE command

GET command  

Hands-On 02: PL/SQL Notepad editing

Open Notepad editor

Save the Oracle Buffer

Edit the file

Work with the file  

Hands-On 03: Basic PL/SQL

Developing a PL/SQL block

Types of block

Anonymous or unnamed block

Components of a PL/SQL block

Declaration

Body or Execution

Exception

Implicit cursor

Explicit cursor

Parameters in cursor  

Hands-On 04: Explicit Cursor Handling

Implicit vs. explicit cursors

Declaring explicit cursors

Using explicit cursor.

Open Cursor

Fetch Cursor

Close Cursor

Declare variable

Using simple loop

Exit statement.  

Hands-On 05: Controlling Process Flow

Using Explicit Cursor Attributes

Conditional Statements and Process Flow

IF ... ELSE ... END IF

LOOP statement

FOR LOOP statement

LOOP statements  

Hands-On 06: Populating table using PL/SQL

Create table.

INSERT statement in PL/SQL block

FOR LOOP statement.

COMMIT statement in PL/SQL block.

Using PL/SQL to access Oracle  

Hands-On 07: Cursor Parameter

How to use parameter(s) in explicit cursor.

FOR LOOP statement.

Declaring Parameters using Explicit cursors

Transaction Processing passing Parameters  

Hands-On 08: EXECPTION

Type of Execptions

Identifying Common Execptions

Coding the Exception Handler

Pre-defined exception

User-defined exception