Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sql/pl-sql/embeded sql?
- 3 Answers
- 12555 Views
- I also Faced
- E-Mail Answers
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 is meant by <> in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What are pl/sql packages?
Is and as keyword in pl sql?
In a distributed database system, can we execute two queries simultaneously?
Why is a trigger used?
How can a function retun more than one value in oracle with proper example?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the default isolation level in sql server? : Transact sql
what is a join? : Sql dba
what are myisam tables? : Sql dba
Does sql full backup truncate logs?
what are the t string functions available in tsql? : Transact sql
Is natural join and inner join same?
What are the sql versions?
