Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 10963 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
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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 read and create .LDC data files which are used by linguatic dictionary.
How would you design a database for an online site, which would average a million hits a day?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
explain detail about ftp in datastage?
How to generate OIDS
Explain the process of the user request and data generating?
Explain the rollup operator?
Explain the cube operator?
How is data stored in dbms?
How to customize error conditions.
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 to combine two function together?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
