Re: Obtaining a views' column origin

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 04 Jul 2002 23:12:40 +0100
Message-ID: <3D24C858.6446@yahoo.com>

Helmut Vogel wrote:
>
> Hi,
>
> i need to obtain the underlying column and table name of a view's column. Can I
> get this info from the data dictionary?
> I use Oracle Server 8.1.6.1.0
> Thanx 4 help!
>
> Helmut
> --
> __________________________________________________________
> News suchen, lesen, schreiben mit http://newsgroups.web.de

xxx_VIEWS has the definition

xxx_TAB_COLUMNS has the column mapping

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Thu Jul 04 2002 - 17:12:40 CDT