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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/06/30
Message-ID: <962385214.4217.0.nnrp-06.9e984b29_at_news.demon.co.uk>#1/1


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.
Received on Fri Jun 30 2000 - 00:00:00 CEST

Original text of this message