How to write a retrieve procedure...

milindgpatil · August 9th, 2005, 06:12 AM

Hi,
I am beginner to oracle.
I want a sp which will contain simple retrieve query like select * from users;[Consider the number of records and columns are more].
Is it Possible to write a query without using INTO statement?
I have heard about reference cursor but I don't have more information about it? If you know the link please specify.

Thanks in advance.

Thanks & Regards,
Milind Patil

_AP · August 9th, 2005, 08:36 PM

http://dbis.informatik.uni-freiburg.....htm#sthref807

milindgpatil · August 9th, 2005, 10:49 PM

Thanks a lot. Its working.

Thanks & Regards,
Milind Patil