PL/SQL

PL/SQL

• PL/SQL is a procedural extension to a non-procedural language SQL.
• PL/SQL is one of the utility of Oracle dbserver and it is not a tool like SQL*plus.
• It is a block-structured languager.
• PL/SQL block is a logical collection of procedural as well as non-procedural statements. It is a data processing language, but  SQL is a powerful Data manipulation Language.
• PL/SQL is having all the features of procedural language as well as all non-procedural features (because of SQL support).
• PL/SQL can used for both Server-Side and Client-Side Development.
• PL/SQL block is a logical collection of procedural as well as non-procedural statements.