Difference between SQL and PL/SQL?

Last updated:9/17/2020 8:22:31 PM

1 Answers

Anonymous User
Anonymous User

The SQL language is standard query language for adding, accessing and manipulating data in RDBMSs. SQL is a

  • Only simple IF / Else statements.
  • Through SQL you can interact with the database through ADO.NET
  • Into SQL we can execute a line of code
  • It can run only on windows

The PL/SQL:

This is referred to as Procedure Language / Structured Query Language:

  • Into the PL/SQL you can execute a block of code not a single line of code.
  • Deep control statements
  • It can run in UNIX also.
  • This Procedure Language (PL / SQL) includes some features of object-oriented programming techniques such as encapsulation, function overloading, and information hiding (all but inheritance).

Answer