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
Explain about network model?
How to generate OIDS
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is the maximum length of an extended property?
Explain about a primary key?
What is an application role and explain a scenario when you would use one?
Explain the rollup operator?
How to use online Backups?
Why does this query return 0?
What is data modeling with example?
How long can an error message be in raiseerror function?
What is dbms and its application?
How is data stored in dbms?
What are the three basic rules which are to be followed for the relational model of the database?
Which four data types cannot be used as a return type from a user-defined function?