Re: Obtaining a views' column origin

agreed to.

would be of no use.

regards

s.kapitza

Jason Baugher <jason_at_baugher.pike.il.us> wrote in message news:<Xns92426FCCF624Ejasonbaugherpikeilus_at_209.242.76.10>...
> 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?
Received on Fri Jul 05 2002 - 18:10:13 CDT