OraFAQ Forum: Server Administration » Re: Get back SQL used to create a view?

Home » RDBMS Server » Server Administration » Re: Get back SQL used to create a view?

Mon, 30 July 2001 11:29

Hans
Messages: 42
Registered: September 2000

Member

SQL> set long 4000
SQL> select text from user_views where view_name='YOURVIEW';

Tue, 31 July 2001 03:53

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: Fri Jul 05 10:19:47 CDT 2024