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

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Fri, 18 Sep 1998 18:20:17 +0200
Message-ID: <36028841.B82D8C2C@psi.de>

Select the view in our tool Hora 3 and choose the command properties. Hora will show you the corresponding SELECT statement of the view. See fttp:\\www.keeptool.com for a 30 days trial version of Hora 3.

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 Fri Sep 18 1998 - 11:20:17 CDT