What is the difference between SQL and PLSQL

Question Posted / prashant

4 Answers
8635 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between SQL and PLSQL..

Answer / sunil bisht

SQL is the only language through which you create or modify
data and structures in Oracle. Although other tools will
connect with the database, they all use SQL to read and
modify data.

Oracle's PL/SQL is a programming lanuguage that extends SQL
to include procedural elements, such as loops and whatnot.

Is This Answer Correct ?

14 Yes

0 No

What is the difference between SQL and PLSQL..

Answer / khan tauseef

SQL is structure Query Language whereas PL/SQL is Procedural
Language Structure Query Language.
SQL does not have Stored Procedures/Stored Functions whereas
PL\SQL has.

Is This Answer Correct ?

10 Yes

1 No

What is the difference between SQL and PLSQL..

Answer / g.sivanagaraju

SQL is a standard structured query language for all the Relational Databases using SQL we can INSERT,UPDATE,DELETE,RETRIEVE and MODIFY the structure of the database.
PLSQL is procedural level extension to the SQL. PLSQL uses Data Manipulation power of SQL and procedural power of some other languages.
PGA gets created by ORACLE SERVER while working in PLSQL environment unlike SQL, SGA.
We can perform complex level validations using PLSQL unlike SQL.

Is This Answer Correct ?

4 Yes

0 No

What is the difference between SQL and PLSQL..

Answer / sap

sql mean data base

Is This Answer Correct ?

2 Yes

7 No

Post New Answer