Advantage: Using cursors we can retrieve multiple records in a plsq block

State the advatage and disadvantage of Cursor's?

Question Posted / shilpa.oracle

2 Answers
9413 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to run sql functions in pl/sql?

992

what is dbms? : Sql dba

934

how mysql optimizes distinct? : Sql dba

1001

what is 'mysqldump'? : Sql dba

1050

what is a trigger in mysql? : Sql dba

1071

how to decrement dates by 1 in mysql? : Sql dba

970

What is nvl?

1019

Does sql full backup truncate logs?

968

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021

Can you join a table to itself?

1034

how to check server status with 'mysqladmin'? : Sql dba

1018

Is big data nosql?

888

What is sql architecture?

985

What are the various levels of constraints?

1061

How do you modify a column in sql?

943