Home » RDBMS Server » Server Administration » Re: Get back SQL used to create a view?
Re: Get back SQL used to create a view? [message #375133] Mon, 30 July 2001 11:29 Go to next message
Hans
Messages: 42
Registered: September 2000
Member
SQL> set long 4000
SQL> select text from user_views where view_name='YOURVIEW';
Re: Get back SQL used to create a view? [message #375144 is a reply to message #375133] Tue, 31 July 2001 03:53 Go to previous message
Jon Sebright
Messages: 1
Registered: July 2001
Junior Member
Brilliant. Thanks.

Jon.
Previous Topic: top-N query
Next Topic: 3 fields into 1 virtual
Goto Forum:
  


Current Time: Tue Dec 24 07:42:04 CST 2024