no Politeknik Perdana Mandiri
Procedural Language/SQL
Post by : admin

PL/SQL : Procedural Language/SQL is Oracle Corporation’s procedural language extension to SQL, the standard data access language for relational databases.

PL/SQL offers modern software engineering features such as data encapsulation, exception handling, information hiding, and object orientation, and so brings state-of-the-art programming to the oracle server and toolset.

 

8 PL/SQL is an extension to SQL with design features of programming languages.

8 Data manipulation and query statements of SQL are included within procedural units of code.

 

Benefit of PL/SQL

* Integration

PL\SQL plays a central role to both the Oracle Server (through stored procedures, stored functions, database triggers, and packages) and Oracle development tools (through Oracle Developer component triggers).

Oracle developer applications make use of shared libraries that hold code (procedures and functions) and can be accessed locally or remotely. Oracle developer consists of Oracle forms, Oracle Reports, and Oracle Graphics.

SQL datatypes can also be used in PL/SQL. Combined with the direct access that SQL provides, these shared datatypes integrate PL/SQL with the Oracle Server data dictionary. PL/SQL brides the gap between convenient access to database technology and the need for procedural programming capabilities.

 

 

 

* Improved performance

PL/SQL can be used to grop SQL statement together within a single block and to send the entire block to the server in a single call, thereby reducing networking traffic. Without PL/SQL, the SQL statements would be processed one at a time.

PL/SQL can also cooperate with Oracle Server application development tools such as Oracle Developer Forms and Reports. By adding procedural processing power to these tools, PL/SQL boosts performance.

 

* Portability

You can move programs to any host environment (operating system or platform) that supports the Oracle Server and PL/SQL.

* Modularity of program development