Re: how to find all user defined views name?

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 - 03:09:22 CDT