What is the difference between SQL and PL/SQL?
1555
28-May-2017
Updated on 20-Sep-2020
Manish Kumar
28-May-2017Sql-
In Sql it is referred as Structured Query Language.
In sql Only simple IF / Else statements.
Using SQL you can interact with database through ADO.NET
SQL can execute a line of code
It can run only on windows
PL/SQL-
It is referred as Procedure Language / Structure Query Language:
In this you can execute a block of code not a single line of code.
Deep control statements
PL/Sql can run in UNIX also.
PL/SQL language includes object oriented programming techniques such as encapsulation, function overloading, and information hiding (all but inheritance).