DBMS Basics of PL/SQL

Basics of PL/SQL

Programming language/structured query language
It provide facility of procedural and function
It provides programming techniques like branching, looping, and condition check.
It is fully structured programming language.
It decreases the network traffic because entire block of code is passed to the DBA   at one time for 
execution.
 

Basic Structure of PL/SQL

PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other. Typically, each block performs a logical action in he program. A block has the following structure:

Syntax:

DECLARE
 /* Declarative section: variables, types, and local subprograms. */ 
BEGIN
 /* Executable section: procedural and SQL statements go here. */
 /* This is the only section of the block that is required. */ 
EXCEPTION
 /* Exception handling section: error handling statements go here. */ 
END;

 



Share This Page on:


Ask Question