Answer Posted / shilpa.oracle
Advantage:
Using cursors we can retrieve multiple records in a plsq block.
Disadvantage:
switching between the plsql statement executor and sql
statement executor at plsql runtime engine will consume time.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is pl/sql language case sensitive?
What do you think about pl/sql?
What is record variable?
What is the main difference between sql and pl/sql?
What are the usages of sql?
What is the maximum database size for sql express?
How do you remove duplicate records from a table?
What is the difference between the conventional and direct path loads? : aql loader
what is offset-fetch filter in tsql? : Transact sql
how to write date and time literals? : Sql dba
What is pl sql in oracle?
what are rollup and cube in t-sql? : Transact sql
What is spool?
Why is sql better than hql?
What is a stored procedure in sql with example?
