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

Explain what is a view?

600


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

582


How do I start sql from command line?

535


How do you remove duplicate records from a table?

511


What are commit, rollback, and savepoint?

569






Is delete faster than truncate?

547


Can we use update in sql function?

583


How delete all records from table in sql?

554


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1710


Is pl sql useful?

540


What is string join?

558


What are the types of subqueries?

573


Can you call pl/sql package functions from within a fast formula?

564


How many indexes can be created on a table in sql?

496


Why coalesce is used in sql?

472