Re: Listing VIEWS

From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 28 Oct 1994 19:54:00 GMT
Message-ID: <38rkso$763_at_jalisco.optimum.net>


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)
>

Of course: select text from user_views (or all_views, or dba_views). (See Appendix B of the Server Administrator's Guide.)

Tim Boemker Received on Fri Oct 28 1994 - 20:54:00 CET

Original text of this message