Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

We have a CURSOR then we need BULK COLLECT?

Question Posted / meetsivanagaraju


We have a CURSOR then we need BULK COLLECT?..

Answer / phanikumar

to retrieve all the record at a time we use BULK COLLECT

but in cursors records will be retrieved one by one in loop. cursors an time taking process .

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

write a query to display diference between two dates in sql server

2 Answers  

What are some predefined exceptions in pl/sql?

0 Answers  

Types of joins ?

11 Answers   Polaris, TCS,

what are the disadvantages of mysql? : Sql dba

0 Answers  




What is a procedure in pl sql?

0 Answers  

How does rowid help in running a query faster?

0 Answers  

what is the use of set statement in tsql? : Transact sql

0 Answers  

What is primary key sql?

0 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

Can we use views in stored procedure?

0 Answers  

How do I view a view in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories