What is the difference between SQL and PL SQL?
SQL | PL/SQL |
---|---|
Stands for Structured Query Language. | Stands for Procedural Language SQL, an extension for SQL. |
Only one single query can be executed at a time. | Multiple codes can be executed at a single time. |
It is used to store data to be displayed | It's the language through which an application is created to display data |
PL SQL statements cannot be embedded in the code | SQL statements can be embedded in the code |
Used to write queries and commands using DDL and DML methods | Used to write a block of code for having procedures, variables, functions and packages |
BY Best Interview Question ON 30 Jan 2020