Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to find all user defined views name?
Also, check out the manual "Reference" at:
http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/nav/do
cindex.htm
"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 Mon Oct 21 2002 - 21:28:41 CDT