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.