Answer Posted / 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 View All Answers
What is compound trigger?
how to create a test table in your mysql server? : Sql dba
What is a memo field?
Does sql require a server?
what are date and time data types in mysql? : Sql dba
What is a pl/sql block?
Why do we use triggers?
What is pls integer?
how to fetch common records from two tables? : Sql dba
How to fix oracle error ora-00942: table or view does not exist
how do you control the max size of a heap table? : Sql dba
What is a call statement? Explain with an example.
How do I find duplicates in a single column in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
how are mysql timestamps seen to a user? : Sql dba