How is the performance of Oralce improved by PL/SQL in Oracle?
Without PL/SQL the ORACLE RDBMS must process sql statements one at a time, Each Sql statement results in another call to RDBMS and higher performance overhead. This overhead can be significant when you are issuing many statement in a network environment. With the PL/SQL all the SQL statements can be sent to RDBMS at one time. This reduces the I/O operations. With Pl/SQL a tool like Forms can do all data calculations quickly and efficiently without calling on the RDBMS .
