Re: how to find all user defined views name?

Another great place to look is in DICT. If you can't remember which data dictionary object to use, try the following query:

SELECT * FROM dict WHERE comments LIKE '%view%';

You can substitute "view" for "table", "function", etc.

HTH,
Brian

Tree4 wrote:
>
> Further to Karstens suggestion, you might want to run the following
> query which will give an idea of how to find out the name of 'useful'
> views.
>
> Select Object_name from all_objects where object_name like '%VIEW%';
>
> Karsten Farrell <kfarrell_at_medimpact.com> wrote in message news:<mrZs9.166$8l4.18855076_at_newssvr14.news.prodigy.com>...
> > Avnish Pundir wrote:
> > > Hi there,
> > > Sorry its very basic question for which I can't find answer on google or
> > > oracle online docs.
> > > Can someone pls tell me how to see all defined views name for any oracle db?
> > > Is there any table name which contains name of all views. I know how to
> > > create/replace/delete one but what am looking for is way to see all user
> > > defined views name.
> > > Any help would be greatly appreciated.
> > >
> > > Thanks
> > > Avnish
> >
> > Look at USER_VIEWS, ALL_VIEWS, and DBA_VIEWS depending on whether you
> > want to see just yours, ones you can access, or everybody's views. Pay
> > special attention to the VIEW_NAME column.
Received on Tue Oct 22 2002 - 10:54:05 CDT