Re: Obtaining a views' column origin

Ok, I can read the view's definition in xxx_views. But there's no mapping between the columns of a view and its underlying table in xxx_tab_columns. What I need is a function like GetBaseTablename(view,column). Thank you
  Helmut

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>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..."

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de