What is a REF CURSOR? Compare strong and week ref cursor types.

Answer Posted / sure

ref cursor is a datatype we can assign variables that data type called cursor variable,cursor variable can associate with different queries at run time,primary advantage of refcursor is we can pass result set morethan one sub program

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is id a reserved word in sql?

668


what is the difference between clustered and non clustered index in sql? : Sql dba

553


What does the argument [or replace] do?

583


What is thread join () in threading?

542


What is the use of sqlerrd 3?

523






what is meant by urlencode and urldocode? : Sql dba

603


Are stored procedures faster than queries?

524


What are the string functions in sql?

530


Does truncate free space?

520


Which are the different character-manipulation functions in sql?

550


what is a trigger? : Sql dba

580


How to sort the rows in sql.

605


what are the types of subquery? : Sql dba

592


what is error ora-03113: end-of-file on communication channel?

607


How many sql databases can you have on one server?

597