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 |
Why is pl sql needed?
What is sql architecture?
How can I speed up sql query?
Can we use ddl statements in stored procedure?
Which join is default?
What are field types?
What does seeding a database mean?
What are aggregate functions in sql?
Why do we use function in pl sql?
How do I edit a trigger in sql developer?
How to fetch records from a partitioned table?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.