What are the Diff B/W Cursor and REF Cursor

Answer Posted / guest

Cursor is Static
REF Cursor is Dynamic

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the syntax for using sql_variant_property? : Transact sql

533


how can we know the count/number of elements of an array? : Sql dba

576


What is the purpose of design view?

527


What does desc stand for?

593


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

690






What is compilation error in pl sql?

504


What port does sql server use?

510


Which one is better subquery or joins?

557


Explain normalization and what are the advantages of it?

518


What does over partition by mean in sql?

533


How can you load multi line records? : aql loader

657


how to check server status with 'mysqladmin'? : Sql dba

570


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2007


What is file based approach?

491


Why use subqueries instead of joins?

607