1.

Differentiate between SQL and PL/SQL.

Answer»
SQLPL/SQL
SQL is a natural language meant for the interactive PROCESSING of data in the database.PL/SQL is a procedural extension of SQL.
Decision-making and looping are not allowed in SQL.PL/SQL supports all features of procedural language such as CONDITIONAL and looping statements.
All SQL statements are executed at a time by the database SERVER which is why it becomes a time-consuming process.PL/SQL statements are executed one BLOCK at a time thereby reducing the network traffic.
There is no error handling mechanism in SQL.This supports an error handling mechanism.


Discussion

No Comment Found