PL/SQL is Oracle's procedural EXTENSION to SQL. With PL/SQL, we can manipulate DATA with SQL statements, and control program flow with procedural CONSTRUCTS such as IF-THEN and LOOP. we can also declare constants and variables, define procedures and functions, use COLLECTIONS and object types, and trap run-time errors. Applications written using any of the Oracle programmatic interfaces can call PL/SQL stored procedures and send blocks of PL/SQL code to the server for execution. Because it runs inside the database, PL/SQL code is very efficient for data-intensive operations, and minimizes network traffic in client/server applications.

PL/SQL is Oracle's procedural extension to SQL. With PL/SQL, we can manipulate data with SQL statements, and control program flow with procedural constructs such as IF-THEN and LOOP. we can also declare constants and variables, define procedures and functions, use collections and object types, and trap run-time errors. Applications written using any of the Oracle programmatic interfaces can call PL/SQL stored procedures and send blocks of PL/SQL code to the server for execution. Because it runs inside the database, PL/SQL code is very efficient for data-intensive operations, and minimizes network traffic in client/server applications.