USER_VIEWS « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. USER_VIEWS
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