Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Getting a list of your own views

SQL> SQL> SELECT view_name FROM user_views where rownum < 50; VIEW_NAME ------------------------------ APPLICATION_USERS AUTHOR_PUBLICATION AVG_EVALUATIONS COURSE_DAYS CRS_OFFERINGS DEPT20_V DEPT_OR EMP_V EMP_VIEW HRC_ORG_SITE SALES_BY_ATLAS_V SALES_PER_PERSON_V USER_AVAIL_TRACE_FILES 13 rows selected. SQL>