Re: Listing VIEWS

In article <38rkso$763_at_jalisco.optimum.net>, Tim Boemker <tim_boemker_at_zacatecas.optimum.com> wrote:
>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

Also, remember that TEXT in that view is a LONG. You will have to:

SQL> _SET ARRRYSIZE 1_
SQL> _SET LONG 8000_ and then execute your select. This will give you the entire view.

Mike

--
============================================================================
Mike Vergara           |   Be good...and you will be lonesome
vergara_at_nosc.mil       |                                       Jimmy Buffett
Opinions expressed are not necessarily those of anyone else but me.  So there.