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

how to fetch common records from two tables? : Sql dba

882


What is the use of <> sql?

766


Which are the different types of indexes in sql?

807


What is graph sql?

755


What does cursor do in sql?

766


Does mysql support pl sql?

868


How show all rows in sql?

829


What is autocommit sql?

753


How to create an array in pl/sql?

812


Can a table contain multiple foreign key’s?

775


What is a nested table in word?

736


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1381


Does truncate remove indexes?

764


How is sql used in oracle?

790


Why query optimization is needed?

714