What is the difference between sql/pl-sql/embeded sql?
Answer Posted / 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 |
Post New Answer View All Answers
How to process query result in pl/sql?
How to display the records between two range in Oracle SQL Plus?
How many types of cursors are available in pl/sql?
What is difference between db2 and sql?
What is trigger and types?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Why do we use set serveroutput on?
How can triggers be used for the table auditing?
Explain locks? : Transact sql
What is crud sql?
What is scalar function?
Does mysql support pl sql?
How do temporal tables work?
How do you concatenate in sql?
What does pl sql stand for?