OraFAQ Forum: SQL & PL/SQL » Ref curosr or Collections

Home » SQL & PL/SQL » SQL & PL/SQL » Ref curosr or Collections (Oracle 9i)

Thu, 17 July 2008 00:52

subbu_tce
Messages: 98
Registered: July 2007
Location: pune

Member

Dear All,
We can populate the data from a table using collections also and using ref cursors also.Which one is better in performance wise?

Thu, 17 July 2008 01:22

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.
It depends.

Regards
Michel

Previous Topic:	How many OUT REF CURSOR arguments can be defined in a procedure
Next Topic:	List of jobs created thru DBMS_SCHEDULER

Goto Forum:

]

Current Time: Tue Sep 16 22:28:04 CDT 2025