Interested to Buy Any Domain ? << Click Here >> for more details...
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
How many parts of a pl sql block are optional?
Mention what plvcmt and plvrb does in pl/sql?
what are the 'mysql' command line options? : Sql dba
how to calculate the difference between two dates? : Sql dba
What are the different datatypes available in PL/SQL?
what is subquery? : Sql dba
Is json a nosql?
Explain locks? : Transact sql
Why do we use sql constraints? Which constraints we can use while creating database in sql?
how many groups of data types? : Sql dba
what are the drivers in mysql? : Sql dba
what is not null constraint? : Sql dba
Can we create a trigger on view?
What is normalization in sql?
what is self join and what is the requirement of self join? : Sql dba
