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
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the cube operator?
In which table collections errors are stored.
What are the three types of database design?
What is normalization? Explain different levels of normalization?
Explain about the hierarchical model of the database?
What is the maximum length of an extended property?
How long can an error message be in raiseerror function?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about relational database management systems?
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).
How to replace not in with not exist?
Who are naive users?
What is DB Development software?
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