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 - 15:28:02 CDT
