What is the difference between sql/pl-sql/embeded sql?

Questions by arunima

Showing Answers 1 - 3 of 3 Answers

Shreya

  • Mar 2nd, 2006
 

SQL is Structured Query Language used for DDL,DML.

PL/SQL is used for Cursors and Triggers

Embeded SQL is used to embed SQL statements in  C,Cobol,Pascal,Foxpro like languages.

  Was this answer useful?  Yes

psom

  • Jun 8th, 2006
 

 

 

Embedded SQL - SQL statements are invoked from a host environment like C/C++, Java or any other programming languages.

  Was this answer useful?  Yes

SQL is a structured query language.Used to perform operations such as retrieval,updations,insertions etc. on database.


PL/SQL is a Programming language which is an extension for SQL with control structures added to them.Number of SQL statements can be written together in PL/SQL.


Embedded SQL is nothing but embedding SQL statements in high level languages like C,C++ etc.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions