What are the disadvantages of cursors? How can you avoid
cursors?
Answer Posted / gogune s k
Overload for RAM to process each row and time consuming.
Bulk collect can be used in place of cursors in some cases.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to generate OIDS
What is database design and development?
What are the 18 schemas?
What are the three types of database design?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What is dbms explain in brief?
What is DB Development software?
What are data modelling techniques?
What is normalization? Explain different levels of normalization?
What are the key features of dbms?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How can I detect whether a given connection is blocked?
What is the database development process?
Explain the rollup operator?