 |
- Procedural language extension to sql with design feature of programming language
- Data manipulation and query statements of sql are included with in procedural units of code.
- It is mainly used to reduce the network traffic
- Pl/sql statement is used to group the set of sql statement into single block and send the entire block to the server in a single call (here set of sql statement can execute at a single time)
- It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL.
PL/sql Engine
- Oracle uses a PL/SQL engine to processes the PL/SQL statements.
- A PL/SQL code can be stored in the client system (client-side) or in the database (server-side).
The program unit is stored in a database. When an application calls a procedure stored in the database, Oracle loads the compiled program unit into the shared pool in the system global area (SGA). The PL/SQL and SQL statement executors work together to process the statements within the procedure.
Reference : http://docs.oracle.com/cd/B19306_01/server.102/b14220/sqlplsql.htm
