sql and pl-sql difference in Oracle
1) We can execute more than one commands at a time in pl-sql,but not allow to execute more than one
command in SQL.
2) Code re usability available in pl-sql,but not allow in SQL.
3) Pl-sql provide facility of condition checking,branching and looping.
4) PL-SQL will run faster in the version 10g than it did in previous versions.Oracle has made PL-SQL code
run faster without requiring additional work on the part of the programmer.
In SQL, many new commands allows you to retrieve information or data more easily than the before.
0 comments :
Post a Comment