1. Home
  2. Engineering
  3. CS/IT Engineering
  4. Database
  5. PL/SQL Interview Questions
  6. Differentiate between PL/SQL and SQL?

Differentiate between PL/SQL and SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ select/ updates/ delete. SQL is a query language that allows you to execute a single insert/ delete/ update. The following are the notable differences between SQL and PL/SQL:

SQLPL/SQL
SQL is a data-oriented language which is very useful for interactive processing.PL/SQL is a procedural language to create applications. It is an extension of Oracle.
SQL doesn’t have any procedural capabilities like condition testing, looping. It tells the database what to do and not how to do.On the contrary, PL/SQL offers procedural capabilities like condition testing, looping, etc. it also offers high language features.
SQL is executed by the database one statement at a time. It is a time-consuming process.PL/SQL is less time consuming as compared with SQL. It sends the block of codes to the database server at the same time.
There are very less chances of error handling in SQL. 

    Related Questions

    Please Login or Register to leave a response.

    Subscribe Our NewsLetter

    Never Miss an Articles from us.

    Recent Articles
    Featured Categories

    Related Questions

    PL/SQL Interview Questions

    What is PL/SQL?

    PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..

    PL/SQL Interview Questions

    State few characteristics of PL/SQL?

    Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..

    PL/SQL Interview Questions

    Enlist the data types that can be used in PL/SQL?

    Each constant, value and parameter has a data type that tells us the type of data used and their associated operations i..