Re: Create a view to return multiple rows based on the column values of a single row, How?

Have a look at my website,
there is a function (based on using
object types) that will return a
thing that looks like a table, and
will answer your requirement exactly.

    miscellaneous -> dummy data

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

adamvt_at_my-deja.com wrote in message <8jiijh$frc$1_at_nnrp1.deja.com>...


>Thanks for the hints.  I think I missed to mention that I have a

>restrictive environment and I don't wanna create a new table.  I need

>to do this possibily by creating functions at most.

>

>Thanks again,

>Adam

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.