What is the difference between sql/pl-sql/embeded sql?
- 3 Answers
- 11793 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 are sql*plus environment variables?
Can a table have no primary key?
Which certification is best for sql?
how to use regular expression in pattern match conditions? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
What port does sql server use?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
How you improve the performance of sql*loader? : aql loader
what is csv? : Sql dba
Explain sql data types?
How to fetch alternate records from a table?
what are the differences among rownum, rank and dense_rank? : Sql dba
How can triggers be used for the table auditing?
Write an sql query to select all records from the table?
