just add calculated fields
eg
select first_name, last_name, last_name||', '||first_name full_name from
emp;
Jim
"Jan van Toor" <jan_at_vtwebs.nl> wrote in message
news:FcHW8.596984$yP6.17381542_at_Flipper...
> Hello,
>
> With Interbase (Borland Database) I can create Stored Procedures, which
> return resultsets. I
> have found out that it is possible do the same thing with Oracle, using
> packages and REF CURSOR.
>
> In Interbase, however, I was able to select a resultset, fetch each record
> of it, add some extra fields to the record (calculations etc) and after
that
> SUSPEND the extended record.
>
> I have seen lots of examples in Oracle opening a cursor, but no example of
> adding extra info to a record and then return thát record.
>
> Could you send me such an example?
>
> Thanks in advance
> Jan van Toor
>
>
>
>
Received on Tue Jul 09 2002 - 21:39:20 CDT
