Re: Obtaining a views' column origin

From: Helmut Vogel <Helmut.Vogel_at_web.de>
Date: 5 Jul 2002 21:00:51 +0200
Message-ID: <3d25ece3$1@netnews.web.de>

Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote:
>> Helmut Vogel <Helmut.Vogel_at_web.de> wrote in
>> news:3d256ad6$1_at_netnews.web.de:
>>

>>> 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..."
>>> 

>>
>> I don't think it exists. It sounds like you want to input the view
>> name and the column, and have the function query the view description
>> and somehow parse out the select statement for the view to just give
>> you the relevant info for that column. But views can sometimes have
>> very complex queries, with subqueries, etc... that would make it very
>> hard to do something like that automatically.
>>
>> Anyone disagree with me?

>
>
>No, definitely not!
>
>create view x as select a.y+b.z as q from some_table a, another table b 
>where
>a.id = b.id;
>
>would get  GetBaseTablename(x,q)  in troubles.
>
>Rene
>
>
>
>
>
>-- 
>Recherchen im schweizerischen Handelsregister: 
>http://www.adp-gmbh.ch/SwissCompanies/Search.php3
>

In such a case the function should return NULL, that's obvious. To parse the view's text is not what i want. Isn't the information stored anywhere in the system tables?

Helmut

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

Received on Fri Jul 05 2002 - 14:00:51 CDT