Oracle9i笔记1(2)

Benefits of PL/SQL

PL/SQL bridges the gap between convenient access to database technology and the need for procedural programming capabilities.

PL/SQL 為數據庫提供的接口和程序需求之間架起了一座橋梁。

PL/SQL can improve the performance of an application. The benefits differ depending on the execution environment.

PL/SQL 能改善應用程序的性能。使執行環境不同。

PL/SQL can be used to group SQL statements together within a single block and to send the entire block to the server in a single call, thereby reducing networking traffic.

PL/SQL 把一組語句集成一個集合，應用程序只要發送一個命令調用就行了。因此使網絡流量減少，程序運行速度提升。

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

PL/SQL 也可以Oracle 的其它高級工具像Oracle Forms 和 Oracle Reports 一起工作。并增加程序能力，加強語言性能。

PL/SQL Block Structure

Every unit of PL/SQL comprises one or more blocks. These blocks can be entirely separate or nested one within another. The basic units(procedures, functions, and anonymous blocks ) that make up a PL/SQL program are logical blocks, which can contain any number of nested subblocks.

PL/SQL is portable. 方便

You can declare variables. 能定義變量。

PL/SQL is native to the Oracle server, you can move programs to any host environment that supports the Oracle server and PL/SQL. In other word,

PL/SQL programs can run anywhere the Oracle server can run; you do not need to tailor them to each new environment.

Oracle server 能運行的地方PL/SQL 也能運行。不用再為其構造環境。

You can program with procedural language control structures. PL/SQL can handle errors.

Benefits of Subprograms

Easy maintenance

Improved data security and integrity Improved performance Improved code clarity

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新人文社科Oracle9i笔记1(2)全文阅读和word下载服务。