What is the difference between sql/pl-sql/embeded sql?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What does 0 mean in sql?
What is CYCLE/NO CYCLE in a Sequence?
How does sql*loader handles newline characters in a record? : aql loader
What are the types of triggers in sql?
Can I join the same table twice?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How do you drop a trigger?
What is referential integrity ?
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?
What is the difference between delete, truncate and drop command?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints