USER_VIEWS « System Tables Views « Oracle PL / SQL






1.Query user_views
2.Query user-defined view info from USER_VIEWS table
3.Get all views
4.If view exists, drop view
5.List view text from user_views