Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sql/pl-sql/embeded sql?
- 3 Answers
- 12607 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 schema means?
What are the various restrictions imposed on view in terms of dml?
Where not exists in sql?
Is it possible to read/write files to-and-from PL/SQL?
What is data definition language?
how many sql dml commands are supported by 'mysql'? : Sql dba
Why is %isopen always false for an implicit cursor?
How to Execute a Package in PL/SQL.?
what are different types of collation sensitivity? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the primary use of normalization?
what are the difference between clustered and a non-clustered index? : Sql dba
What is trigger point?
How is a PL/SQL code compiled?
What is the command used to fetch first 5 characters of the string?
