Re: Discovering the definition for a view?

You may also want to retrieve the names of the columns from the view. You won't always get this from the view text.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:956853715.29742.0.pluto.d4ee154e_at_news.demon.nl...
>
> 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 Fri Apr 28 2000 - 00:00:00 CDT