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
rakas22
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
rleishman
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: Sat Dec 10 02:57:02 CST 2016

Total time taken to generate the page: 0.04541 seconds