Re: Listing VIEWS

From: Theresa Stone <stone2_at_niehs.nih.gov>
Date: 1 Nov 1994 08:45 EST
Message-ID: <1NOV199408455612_at_niehs.nih.gov>


In article <38rfh8$jh2_at_youth.yth>, msbeebe_at_mtu.edu (Matt Beebe) writes...
>Is there a way to get the select statement for a view after it has been
>created? (Oracle V7 on Sun)
>
>thanks in advance,
>
> -Matt

select text from user_views where view_name = '<view name>';

Set maxdata and long to something large and increase as necessary in order to be able to retrieve the entire text. Spooling to a file might be a good idea too.

Theresa Received on Tue Nov 01 1994 - 14:45:00 CET

Original text of this message