Getting a list of your own views : user_views « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
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>
SQL>








30.110.user_views
30.110.1.You can get information about your views from user_views
30.110.2.Getting a list of your own views