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
| 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.
Sir I want download offline website…by HTTract…how I do this…plz send me
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
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
Rajasekhar
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….