Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 11070 Views
- I also Faced
- E-Mail Answers
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
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What is the database development process?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
In which table collections errors are stored.
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?
explain detail about ftp in datastage?
How to generate OIDS
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 you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is DB Development software?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What is a database development?
What are the types of database model?
How to use timestamp datatypes
