Re: Listing VIEWS
From: Joseph Bennett <bennettj_at_news-server>
Date: 1 Nov 1994 21:02:36 GMT
Message-ID: <396adc$e48_at_nuclear.microserve.net>
Date: 1 Nov 1994 21:02:36 GMT
Message-ID: <396adc$e48_at_nuclear.microserve.net>
Matt Beebe (msbeebe_at_mtu.edu) wrote:
: Is there a way to get the select statement for a view after it has been
: created? (Oracle V7 on Sun)
This script should do the trick.....
SET LONG 2048
SET HEAD OFF
SELECT TEXT FROM USER_VIEWS WEHRE VIEW_NAME = 'yourviewname';
: thanks in advance,
: -Matt
Received on Tue Nov 01 1994 - 22:02:36 CET