Re: Obtain information about columns in views

niimrod wrote:

> Does anyone know a query I can run against the DBA_xxx views to get
> the names of the columns in
> a view? For tables exist SYS.ALL_TAB_COLUMN, but thers's nothing ike
> thsi for views.

Did you try to query SYS.ALL_TAB_COLUMNS for TABLE_NAME='<your-view-name>'?

-- 
« Se la pena è necessaria, non la si deve cancellare ;
se non è necessaria, non la si deve pronunziare. »
(Jeremy Bentham)