PL/SQL Introduction

PL/SQL.

  

Block Structure approach. 

  

A simple PL/SQL Block.

  

Executing statements and PL/SQL blocks from SQL*Plus. 

  

Types of blocks in PL/SQL.

  

Comments in PL/SQL. 

  

Variables in PL/SQL.

  

Handling variables in PL/SQL.

  

Types of Variables in PL/SQL.

  

Operators in PL/SQL.

  

Assigning values to a variable.

  

Declaring PL/SQL Variables.

  

Debugging statement.

  

Variable scope and Nested Blocks.

  

How to convert the anonymous block to label block.