Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtain information about columns in views

Re: Obtain information about columns in views

From: codadilupo <codadilupo_at_operamail.com>
Date: Wed, 28 Nov 2007 15:23:17 +0100
Message-ID: <474d79d5$0$7736$5fc30a8@news.tiscali.it>


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)
Received on Wed Nov 28 2007 - 08:23:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US