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

How do I kill a query in postgresql?

755


Why cross join is used?

825


how to install mysql? : Sql dba

792


What is the cause of mutating table error and how can we solve it?

786


What sql does db2 use?

726






What is example of database?

701


Is and as keyword in pl sql?

686


What is replication id?

683


What sql database should I use?

788


What are the 3 types of behavioral triggers?

943


Do we need to rebuild index after truncate?

703


What are the disadvantages of file system?

828


What is mutating trigger?

768


What is the example of procedure?

678


How many times can we commit in a loop?

740