finding out how a view was constructed 1

[meumax]

If someone else has created a view in Oracle, how can I find out how it was put together? Specifically, I want to know what was the SQL statement used as the basis for the view or failing that, what tables each of the fields in the view comes from.

Using the describe command gives me the fields in the view, but tells me nothing of where those fields come from or the selection criteria used for the view.

 

[jimbopalmer]

select text from user_views where view_name = 'MYVIEW'; I tried to remain child-like, all I acheived was childish.

 

[blom0344]

ORACLE's schema manager lets you choice the schema in which the view is created and just clicking the view in the list will display the SQL that constitues it. As far as I know schema manager is part of enterprise manager and can be installed as part of the server installation.......... T. Blom
Information analyst
tbl@shimano-eu.com