Difference between SQL and PL/SQL

Here you will learn about difference between SQL and PL/SQL.

SQL and PL/SQL are two popular database technologies. These two topics are very frequently asked in database interviews.

In this article I have shared the key differences between these two technologies.

Also Read: PL/SQL Interview Questions and Answers

Difference between SQL and PL/SQL

Image Source

Difference between SQL and PL/SQL

S. No. SQL PL/SQL
1. SQL Stands for Structured Query Language PL/SQL stands for Programming Language SQL.
2. SQL is used to execute single query or statement at a time. PL/SQL is used to execute block of code or program that have multiple statements.
3. SQL tells the database what to do but not how to do. So it is declarative. PL/SQL tells the database how to do things. So it is procedural.
4. SQL can be used in PL/SQL programs. PL/SQL can’t be used in SQL statement.
5. SQL is used with various database systems like MySQL, SQL Server, Oracle, DB2, etc. PL/SQL is used only with Oracle database.
6. An example of SQL query is given below.

SELECT * FROM Customers;

An example of PL/SQL program is given below.

BEGIN 

dbms_output.put_line(‘Hello Workd’);

END;

/

 

Comment below if you found any information incorrect or missing.

One thought on “Difference between SQL and PL/SQL

  1. sooraj

    Sir I want download offline website…by HTTract…how I do this…plz send me

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *