What is REF Cursor?

Answer Posted / suresh

Ref cursor is a dynamic cursor. it will open more then one active set area.we two types of ref cursors.
1.strong ref cursor-with return type.
2.weak ref cursor- with out return type.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does appl_top directory contain?

652


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1980


What are do's and dont's of Interface?

1909


What is sca and how is it useful?

663


How to move the one file from one instance to another instance? And your scripts also?

617






What is a flexfield? List out its types.

669


What are the different components of soa suite?

728


Can you explain the difference between architecture followed in 10g & 11g?

667


q)what are the validations in sql*loader

1746


What is oracle soa suite?

771


how do you describe O2C along with tables

2315


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

641


In sequence i want to 11 and 15th values how we will write?

1577


what are the prerequisites for costing transactions?

2636


What do you understand by a set of books?

650