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
|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.
Comment below if you found any information incorrect or missing.
5 thoughts on “Difference between SQL and PL/SQL”
Sir I want download offline website…by HTTract…how I do this…plz send me
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.
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
Both must have to learn first SQL and next PL/SQL.both are mandatory.
Within these points you just made a lot things clear…. thanks….