pl/sql 可以提升性能

 

Improved performance:
Without PL/SQL, you would not be able to logically combine SQL statements as one unit.
没有pl/sql 你可能 不能够 把 sql 语句 逻辑化的 组织 成一个单元

If you have designed an application containing forms, you may have many different forms with fields in each form.
如果你需要设计一个应用,这个应用包含多个表单.不同的表单又包含很多域值

 

When a form submits the data, you may have to execute a number of SQL statements.
当一个表单提交数据,你需要执行若干sql语句

 

SQL statements are sent to the database one at a time.
sql语句被发送到数据库,每次发送一条

 

This results in many network trips and one call to the database for each SQL statement,
这个结果 导致许多网络传输,同时每一个sql语句都需要调用一次数据库

 

thereby increasing network traffic and reducing performance (especially in a
client/server model).
从而增加了网络堵塞,和降低性能(特别是C/S 模式)

 

With PL/SQL, you can combine all these SQL statements into a single program unit.
使用pl/sql ,你可以组织所有的sql语句形成单一的程序单元.

 

The application can send the entire block to the database instead of sending the SQL statements
one at a time.
应用程序可以发送全部的程序块给数据库. 而不是每次只发送一个sql语句

 

This significantly reduces the number of database calls.
这会显著地降低数据库调用的次数

 

As the slide illustrates, if the application is SQL intensive,
如幻灯片的插图所示,如果应用是sql集成的,

you can use PL/SQL blocks to group SQL statements
你可以使用pl/sql 程序块 来组织 sql 语句

before sending them to the Oracle database server for execution.
在把它们送到数据库服务器执行之前.