What is difference between cursor and ref cursor?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

759


What is a dynamic query?

785


How to avoid using cursors?

797


How can you load multi line records? : aql loader

823


Is delete faster than truncate?

778


What is the most restrictive isolation level? : Transact sql

803


Why is sql*loader direct path so fast?

826


What is sql used for?

871


Can we join same table in sql?

756


What is pivot in sql?

694


What does desc stand for?

825


What are the two types of periodical indexes?

691


how to drop an existing view in mysql? : Sql dba

817


In a distributed database system, can we execute two queries simultaneously?

769


Can variables be used in sql statements?

773