Re: Description of View

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Mar 2007 07:08:27 -0700
Message-ID: <1174486107.653668.318090@n76g2000hsh.googlegroups.com>

On Mar 20, 10:09 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "mike" <hil..._at_charter.net> wrote in news:1174434363.681808.33740
> @p15g2000hsd.googlegroups.com:
>
> > Is there any way I can look at the description of the view?
>
> > I'd like to be able to see the field names, type of field, length, etc.
>
> SQL> DESC YOUR_VIEW
To add to Ana's response

View column information appears in dba_tab_columns just like table information.

The view source SQL is available via dba_views.

HTH -- Mark D Powell -- Received on Wed Mar 21 2007 - 09:08:27 CDT