SQL

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
Ebook Download
View all
Basic SQL Queries
Read by 19.4k people
Download Now!
Learn
View all
Membership not found