Re: DD views for view columns

Joerg Blaese wrote:
>
> Hi,
> can anybody tell me which DD view (user_..., etc) contains the column
> part of a view definition?
>
> create or replace view ...
> (
> col1,
> col2,
> ...,
> coln
> )
> as select
> ...
> I'm interested in the col... part, but user_views gives me only the
> select... part.

        Look at USER_TAB_COLUMNS, ALL_TAB_COLUMNS & DBA_TAB_COLUMNS views

Regards

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru