Welcome To PL/SQL

1. PL/SQL stands for PROCEDURAL Language Extension to SQL.
2. PL/SQL extends SQL by adding programming structures and subroutines available in any high level language.
3. PL/SQL can be used for both Server-side and Client-side Development.PL/SQL has syntax and rules that determine how programing statements work together.
4. PL/SQL is not a stand alone Programing Language.
   PL/SQL is a part of the ORACLE RDBMS, and hence can reside in two environments, the CLIENT and the SERVER.
   Any MODULE that is developed using PL/SQL can be moved easily between SERVER SIDE and CLIENT SIDE applications.
   Either in CLIENT/SERVER environments any PL/SQL Block or the PL/SQL Engine Processes Subroutine.
   PL/SQL Engine is a special component that processes and executes any PL/SQL statements and sends any SQL statement to the SQL statement processor.
   The SQL statement processes are always located on the ORACLE SERVER.
5. As per the necessity the PL/SQL Engine can be located either at
         a)SERVER
         b)CLIENT
6. When PL/SQL Engine is located upon the SERVER, the whole PL/SQL block is passed to the PL/SQL Engine on the ORACLE SERVER.
7. When the PL/SQL Engine is located upon the CLIENT, the PL/SQL processing is done on the CLIENT SIDE. All SQL statements that are embedded within the PL/SQl block, are sent to the ORACLE SERVER for further processing.
          a)If the PL/SQL block does not contain any SQL statements, the entire block is executed on the CLIENT SIDE.