Re: Beginner's question on Oracle stored procedure/function---HELP!!

Dana Jian wrote:
>
> Hello,
>
> I'm a new user of PL/SQL in Oracle8, I have two questions as following:
>
> 1) Can function in Oracle server return more than one value? how?
>

No -- functions return zero or one value. That's it...
>
> 2) Can function in Oracle server return a recordset--multiple rows with
> multiple columns? How??

Yes -- with an array. Not familiar with the details -- try looking up "array processing"
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730