Getting Information on View Definitions with user_views view

You can also retrieve information about your views from the user_views view.

Some of the columns in user_views:

ColumnTypeDescription
view_nameVARCHAR2(30)Name of the view
text_lengthNUMBERNumber of characters in the view's subquery
textLONGText of the view's subquery

all_views has retrieve information on all the indexes you have access to.

 
SQL> SELECT view_name, text_length, text
  2  FROM user_views
  3  WHERE view_name = 'EMP_VIEW';

VIEW_NAME                      TEXT_LENGTH
------------------------------ -----------
TEXT
--------------------------------------------------
EMP_VIEW                                85
SELECT "EMPNO","ENAME","JOB","SAL","DEPTNO"
FROM emp
WHERE sal < 1500
WITH READ
Home »
Oracle »
Table » 

Views:
  1. Creating and Using a View
  2. Creating and Using Simple Views
  3. Performing an INSERT Using a View
  4. A View with a CHECK OPTION Constraint
  5. View with a READ ONLY Constraint
  6. Getting Information on View Definitions with DESCRIBE command
  7. Getting Information on View Definitions with user_views view
  8. Retrieving Information on View Constraints
  9. Creating and Using Complex Views
  10. Modifying a View
  11. Alter the constraints on a view using ALTER VIEW
  12. Dropping a View
Related: