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
what happens if null values are involved in expressions? : Sql dba
What is pl sql block structure?
what are myisam tables? : Sql dba
Does truncate table reset auto increment?
What is a natural join sql?
How to take user input in pl sql?
What does joining a thread mean?
what is a composite key ? : Sql dba
What is the use of function "module procedure" in pl/sql?
what is union, minus and interact commands? : Sql dba
What is the left table in sql?
What is the difference between having clause and where clause?
Which software is used for pl sql programming?
define sql delete statement ? : Sql dba
What are the uses of sysdate and user keywords?