Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sql/pl-sql/embeded sql?
- 3 Answers
- 12730 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
how to convert numeric values to character strings? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
what is clause? : Sql dba
What are different functions in sql?
What can I use instead of union in sql?
Which software is used for pl sql programming?
What are character functions?
Does sql require a server?
Show the two pl/sql cursor exceptions.
What is break?
Why do we use view in sql?
What is an emotional trigger?
Is it possible to create startup or shutdown trigger for on-schema?
What are the benefits of triggers?
differentiate between float and double. : Sql dba
