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 form and report?

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

What are the types of triggers in sql?

0 Answers  

How do I remove all records from a table?

0 Answers  

Is delete faster than truncate?

0 Answers  




How do you use join?

0 Answers  

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

What are the uses of merge?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

Is sql low level language?

0 Answers  

What does count (*) mean in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories