|
SQL |
PL/SQL |
| SQL is structural query language for database. It has no variables. | Pl/SQL is a programming language using SQL for database. It has variables and data types |
| SQL has no if condition, loops and similar structures | Pl/SQL has for loops, if condition, while loop and other similar structures |
| SQL can execute single command at a time | It can perform multiple operations at a time |
| SQL is a declarative language | It is a procedural language |
| SQL can be embedded in PL/SQL block | Can also be embedded in SQL code |
| SQL directly interacts with database server.
|
Pl/SQL does not directly interact with database server. |
| SQL is a data oriented language | Pl/SQL is an application oriented language |
| SQL is used to write queries, create and execute DDL and DML Commands | Pl/SQL is used to write program blocks, functions, procedures,triggers and packages |