Re: show a view's sql

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 11 Oct 2005 19:52:20 +0200
Message-ID: <434bfbef$0$24180$9b4e6d93@newsread4.arcor-online.net>

Adam Sandler schrieb:
> Hello,
>
> I cannot find the method to display a view's SQL. Not DESC or SELECT *
> FROM VIEW_NAME but the manner in which I can see the SQL which makes up
> the guts of an existing view. I know I have to SET LONG 2000
> beforehand to see the whole thing but what comes afterwards?
>
> I tried looking at it from Schema Manager as well but the display is
> chopping off a good portion of the existing SQL.
>
> Thanks!
>

You can look it up in the Oracle Reference ( column "TEXT" in views USER_VIEWS, ALL_VIEWS
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2117.htm#sthref1551 , DBA_VIEWS ). Best regards

Maxim Received on Tue Oct 11 2005 - 12:52:20 CDT