Re: How to find which base tables columns are from in a view?

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Thu, 17 Sep 1998 20:05:15 GMT
Message-ID: <36016B7B.57CDBB4E@bechtel.com>

One way is from the data dictionary table DBA_VIEWS. This table has a column called TEXT. This actually contains the command that is used to create the view. It is a long data type column, another column in the table called TEXT_LENGTH will tell you the length of the statement held in the TEXT column (which helps if doing this from SQL*PLUS). You can SET LONG <text_length> so you can see the entire statement.

Dave

Leon Poon wrote:

> Given a view, how can I determine which column is associated with which base
> table? From all_dependencies, I can see which base tables form a particular
> view, but that is only halfway there. Any help would be appreciated, and if
> possible, please cc to lpoon_at_isr.umd.edu. Thanks.
>
> Leon
Received on Thu Sep 17 1998 - 15:05:15 CDT