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.

5 thoughts on “Difference between SQL and PL/SQL”

  1. Hi, Sir
    I am manoj yadav. i amstudying MCA. i want become a software testing engineer so can you tell how to start with basic step or institute who’s provide placement.
    please suggest me.

    Manoj

  2. Hi…sir Iam Rajasekhar present I learn pl/sql programming but I don’t know sql is this right or wrong because I have coaching in insistute they said now pl/sql and told me after some time will explain sql please suggest is this right way or not

Leave a Comment

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