View column information?

Hello everyone,

I'm involved with a task that is trying to establish a mapping of columns in a view to corresponding columns in a table. For instance, suppose we have a table as such:

create table t(

t_pk number(11),

t_value varchar2(1000));

with a view such as

create or replace view t_vw as select t_pk,t_value from t;

This would result in entries populated in the dba_tab_columns view for both t, as well as t_vw. Likewise, the dba_dependencies view will reflect that t_vw references table  t.

However, I don't think it is possible for Oracle to contain a map of view columns to corresponding table columns. Based on the definition of dba_views, I'm suspecting Oracle will execute a view query by simply running the sql defined in the dba_views text column.