SQL Vs PL / SQL

Here i am defining some points regarding SQL and PL / SQL...

SQL


  • Structured Query Language
  • By SQL you can interact with database through ADO.NET
  • Only simple IF / Else statements
  • In SQL you execute a line of code
  • It can run only in windows


PL/ SQL


  • Procedure Language / Structure Query Language
  • In PL / SQL you execute a block of code not a single line of code
  • Deep control statements
  • It can run in UNIX also
  • PL/SQL language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance).
Thanks

Nikhil Kumar
www.dotnetask.blog.co.in
Next Recommended Reading Use of Set Serveroutput In PL / SQL