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: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You could use a Pipelined Function or a REF CURSOR.

Ross Leishman
Previous Topic: ORA-01843: not a valid month -Error
Next Topic: change columns into rows n rows into columns
Goto Forum:

Current Time: Sun Aug 20 14:23:26 CDT 2017

Total time taken to generate the page: 0.04674 seconds