Monday, May 27, 2013

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.



Post a Comment