Difference between SQL and PL/SQL

SQL

Hi!!

Can someone tell me the difference between SQL and PL/SQL?


If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.

1
Answers

Replies

Below explained are the differences between SQL and PL/SQL:



SQL refers to Structured Query Language, is a data-oriented language while PL/SQL or Procedural Language Extension is a application- oriented language.


SQL language is primarily used for creation, retrieval and maintaining the relational database while PL/SQL is primarily used for providing SQL with the procedural capabilities. 


SQL can be embedded inside PL/SQL block while PL/SQL cannot be embedded in SQL code.


SQL is responsible to work with the database server directly whereas PL/SQL does not establish any interaction with the database server.


SQL is capable of handling or executing single operation at a time while PL/SQL allows you to execute multiple operations at once.

 
 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.
WhatsApp
To Top