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

Answers were Sorted based on User's Feedback



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

Answer / madhuri

SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.

PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.

Embedded sql are those statements which are written in host
programs like pro*c,java etc.

Is This Answer Correct ?    10 Yes 2 No

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

Answer / siragam manjunath reddy

Both sql and pl/sql are languages used to acess data with in
oracle data base....sql writtens querys by using ddl,dml,dcl
etc...where plsql uses cursors,triggers,procedures etc..
In sql querys process at a time where as in plsql it done
step by step or recoed by record ...

Is This Answer Correct ?    3 Yes 0 No

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

Answer / swapna

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.

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

Is This Answer Correct ?    5 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

What does 0 mean in sql?

0 Answers  


What is CYCLE/NO CYCLE in a Sequence?

2 Answers  


How does sql*loader handles newline characters in a record? : aql loader

0 Answers  


What are the types of triggers in sql?

0 Answers  


Can I join the same table twice?

0 Answers  


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  


How do you drop a trigger?

0 Answers  


What is referential integrity ?

3 Answers   BirlaSoft,


I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,


Which one is better sql or oracle?

0 Answers  


What is the difference between delete, truncate and drop command?

0 Answers  


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  


Categories