Re: View source code

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Thu, 16 Nov 2000 07:26:29 GMT
Message-ID: <8v0272$om8$1_at_nnrp1.deja.com>

In article <ypDQ5.830$BN.336942_at_paloalto-snr1.gtei.net>, "Buck Eskew" <BEskew_at_gte.net> wrote:
> Does anyone know how to extract the original SQL script that was used
to
> create a view?
>
> Thanks in advance,
> Buck Eskew
>
>
You can select the text of views from ALL_VIEWS,DBA_VIEWS or USER_VIEWS.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 08:26:29 CET

This message: [ Message body ]
Next message: Eric Givler: "Re: View source code"
Previous message: Happl Oberlin: "Re: TTITLE question"
In reply to: Buck Eskew: "View source code"
In reply to Buck Eskew: "View source code"
Next in thread: Eric Givler: "Re: View source code"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message