What is difference between cursor and ref cursor?
Answer / kiran r
Cursor is is pointer which is used access data retrived from database.Cursor is static in nature
ref cursor is datatype variable. whose memory address is working area query in database. it is dynamic in nature and it can be modified at the runtime
Is This Answer Correct ? | 0 Yes | 0 No |
How do I sort a table in sql?
Is subquery faster than join?
Explain the uses of database trigger.
What is the difference between instead of trigger and after trigger?
What is sql basics?
What is fmtonly in sql?
Why join is faster than subquery?
why use cursors?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What do you mean by field in sql?
How do I view an execution plan in sql?
Define overloaded procedure?