Description of all views in the database
Columns ___________________________ OWNER Owner of the view VIEW_NAME Name of the view TEXT_LENGTH Length of the view text TEXT View text TYPE_TEXT_LENGTH Length of the type clause of the object view TYPE_TEXT Type clause of the object view OID_TEXT_LENGTH Length of the WITH OBJECT OID clause of the object view OID_TEXT WITH OBJECT OID clause of the object view VIEW_TYPE_OWNER Owner of the type of the view if the view is an object view VIEW_TYPE Type of the view if the view is an object view SUPERVIEW_NAME Name of the superif view is a subview
Examples (SQL*Plus):
View the definition of myview:
set LONG 1000
select TEXT from DBA_VIEWS
where owner='myowner' and view_name='myview';
1000 should be more than large enough to read most view definitions, but if you want to set this exactly look at the TEXT_LENGTH column:
select TEXT_LENGTH from DBA_VIEWS
where view_name = 'myview';
Related:
ALL_Views