Amritendra kumar

 Profile Answers by Amritendra kumar 

• Feb 28th, 2008

 

sql is structured query language and plsql is procedural sql.
in sql we write a query to fetch the data from data base. in pl sql we write the set of sql command and execute it in one times. the benefit of plsql is its performance. because all the command execute in one time so input output will be fast.

chandu77

 Profile Answers by chandu77 

• Mar 17th, 2008

 

sql is a set oriented language too..This is the basic of any database..PL/SQL is specific to oracle(Procedural language extension to structured query language)

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

 

we can send only one statement through sql where as in pl/sql we can send group of statements

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 21st, 2008

 

Sql is a non procedural language i.e. we  say what to do not how to do . Oracle sql engine itself decides how to do.

Where as pl sql is procedural language. We write program logic and control the execution sequence.

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

sql is structured query language and plsql is procedural sql.
in sql we write a query to fetch the data from data base. in pl sql we write the set of sql command and execute it in one times. the benefit of plsql is its performance. because all the command execute in one time so input output will be fast.

Nazeera Jaffar

• Sep 26th, 2012

 

1.Sql is a declarative language.It tells only what to do.
PL/Sql is a procedural language.It tells what to do and how to do.
2.Sql executes DDL and DML statements .
Pl/Sql executes triggers,functions,procedures and package.
3.sql executes only one statements at a time.
pl/sql executes multiple statements at a time.
4.sql is data oriented language.
pl/sql is object oriented language and supports inheritance etc.
5.We can embed sql statements in a pl/sql.
we cannot embed pl/sql statements in sql