REPOST: Re: View Column Definition?

From: Fernão Magalhaes <barameda_at_no.spam.hotmail.com>
Date: Fri, 25 Jan 2002 21:14:01 -0800
Message-ID: <4$--$%%%_$_$-$%_%$@news.noc.cabal.int>

Try:

    SELECT column_name
    FROM dba_tab_columns
    WHERE table_name = 'TEMP_V1';

--Fernão

<1443131_at_usenetplanet.com> wrote in message news:3c51b9f2.248661796_at_64.154.60.165...

Let's say that I have created a simple view like this:

create ora replace view TEMP_V1(c1)
as
select column1 from TEMP_T1;

Looking up DBA_VIEWS shows the view SQL body definition (select column1 from TEMP_T1). However, I do not know where the column definition (c1) is stored. Where can I find it? Above is very simple example, but for big views with many columns, I need to find out where column definitions are. Thank you in advance.

WAS CANCELLED BY =======: From: "Fernão Magalhaes" <barameda_at_no.spam.hotmail.com> Control: cancel <evylOhipBHA.388_at_cpimsnntpa03> Subject: cmsg cancel <evylOhipBHA.388_at_cpimsnntpa03> Date: Sun, 27 Jan 2002 23:06:30 GMT Message-ID: <cancel.evylOhipBHA.388_at_cpimsnntpa03> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!news-han1.dfn.de!news-koe1.dfn.de!news-was.dfn.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40721050

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 23:14:01 CST