Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL function returning a table?

PL/SQL function returning a table?

From: Rupesh Kapoor <rupesh_at_whowhere.com>
Date: 1997/02/12
Message-ID: <33022BAF.74B9@whowhere.com>#1/1

Hi,

Is there a way to write a PL/SQL function that returns multiple rows (a PL/SQL table of records)?

SELECT pl_sql_func() FROM table_name;

returns only one row at a time.

Thanks
Rupesh Received on Wed Feb 12 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US