Re: Discovering the definition for a view?

Dave Read <dread_at_bladeti.com> schreef in berichtnieuws 39086541.F9DA8ABF_at_bladeti.com...
>
> I have inherited an Oracle database here at work, and I need to figure
> out how the original designer defined a couple of the views. Is there
> any way to do this from the SQL*Plus prompt, or do I have to fire up the
> enterprise manager & dig around in there?
>
> Also, is there any way to alter the view definition?
>
> Thanks,
> Dave

The general answer to this two questions is : RTFM A more specific answer is
1
set long 1000
select text
from user_views
where view_name = '<your view>' (name in uppercase) 2
create or replace view ... etc (I'm not going to repeat the syntax here)

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Apr 27 2000 - 00:00:00 CDT