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
how to fetch common records from two tables? : Sql dba
What is the use of <> sql?
Which are the different types of indexes in sql?
What is graph sql?
What does cursor do in sql?
Does mysql support pl sql?
How show all rows in sql?
What is autocommit sql?
How to create an array in pl/sql?
Can a table contain multiple foreign key’s?
What is a nested table in word?
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
Does truncate remove indexes?
How is sql used in oracle?
Why query optimization is needed?