It isn't store anywhere because it is totally meaningless ... which I
would suggest means you should stop wasting keystrokes typing it.
CREATE OR REPLACE VIEW temp_vi AS
> Let's say that I have created a simple view like this:
> create ora replace view TEMP_V1(c1)
> 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: Mon, 28 Jan 2002 02:47:19 GMT
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 220.127.116.11
Xref: news.uni-stuttgart.de control:40721041
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.