Difference between SQL and PLSQL

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

Leave a Reply

Your email address will not be published.

You May Also Like