REPOST: Re: View Column Definition?

Got anything against

DESC viewname

????

<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: "Alan" <alanshein_at_erols.com> Control: cancel <a2sfai$13mkk9$1_at_ID-114862.news.dfncis.de> Subject: cmsg cancel <a2sfai$13mkk9$1_at_ID-114862.news.dfncis.de> Date: Mon, 28 Jan 2002 02:54:00 GMT Message-ID: <cancel.a2sfai$13mkk9$1_at_ID-114862.news.dfncis.de> 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!cert.uni-stuttgart.de!news.belwue.de!news-stu1.dfn.de!news-koe1.dfn.de!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!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:40721984

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 - 14:34:00 CST