Re: View description

From: Thor <thor_at_echidna.net>
Date: Sun, 18 Oct 1998 18:33:31 -0700
Message-ID: <70e5o0$lsq$1@news.bctel.net>

Alan:
You can get it from any tool!!
In SQL*Plus try this ...

set long 10000
set pages 0
set lines 3000
set trimspool on

spool your_view.sql
select text from all_views where view_name = 'YOUR_VIEW'; spool off

Soap Box: I think it's VERY important to be able to use the basic views provided to developers and dba's. I go to heaps of sites, where people all of a sudden can't do much cause their favourite tool isn't available. I just think it's important.

Thor HW
Alan D. Mills wrote in message <701vh7$40g$1_at_schbbs.mot.com>...
>Using V7.3.4 how can I extract the SQL statement making up a view from the
>syetem tables (or other). I cannot locate the original view creation
script
>yet need to have the SQL for it.
>
>I have looked at ALL_VIEWS but the TEXT column is LONG and so not readable.
>
>Any clues?
>
>--
>Alan D. Mills
>
>
>
>
Received on Sun Oct 18 1998 - 20:33:31 CDT