Very Computer

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.

Got anything against

DESC viewname

????

Quote:

> 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.

    SELECT column_name
    FROM dba_tab_columns
    WHERE table_name = 'TEMP_V1';

--Fern?o

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.

Instead try:

CREATE OR REPLACE VIEW temp_vi AS
SELECT column1
FROM temp_t1;

Daniel Morgan

Instead try:

CREATE OR REPLACE VIEW temp_vi AS
SELECT column1
FROM temp_t1;

Daniel Morgan

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

Got anything against

DESC viewname

????

Quote:

> 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.

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

    SELECT column_name
    FROM dba_tab_columns
    WHERE table_name = 'TEMP_V1';

--Fern?o

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 =======:



Date: Sun, 27 Jan 2002 23:06:30 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,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.