How to list the definition of a View 1

[vicentealeman]

I have 2 DB and 1 of those had a view that is missing; I would like to recreate the view but I am not sure what is inthere
Is there a way to display the definition of a view so I can create the other one ?
Thanks

 

[SantaMufasa]

Vicente,

Use this code:

set long 50000
select text from user_views where view_name = '<your view>';

If you do not own the view, then you can access either ALL_VIEWS or DBA_VIEWS instead of USER_VIEWS.

Let us know if this reasolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 18:06 (15Feb05) UTC (aka "GMT" and "Zulu"),
@ 11:06 (15Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[vicentealeman]

THANK YOU!!!