Home » SQL & PL/SQL » SQL & PL/SQL » return multiple row in function
icon8.gif  return multiple row in function [message #197747] Thu, 12 October 2006 09:13 Go to next message
Messages: 29
Registered: May 2006
Junior Member
hi all

i need to know how to write a function which will return more than one row.

thanks all
Re: return multiple row in function [message #197834 is a reply to message #197747] Thu, 12 October 2006 19:56 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You could use a Pipelined Function or a REF CURSOR.

Ross Leishman
Previous Topic: query by categorized parameter
Next Topic: ORA-00604 Error SQL recursive 1
Goto Forum:

Current Time: Thu Oct 27 22:08:35 CDT 2016

Total time taken to generate the page: 0.06692 seconds