eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_VIEWS

Object Details

Object Name:	ALL_VIEWS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of views accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the view
VIEW_NAME	VARCHAR2	(128)	Yes	Name of the view
TEXT_LENGTH	NUMBER			Length of the view text
TEXT	LONG	(0)		View text
TEXT_VC	VARCHAR2	(4000)		Possibly truncated view text as VARCHAR2
TYPE_TEXT_LENGTH	NUMBER			Length of the type clause of the object view
TYPE_TEXT	VARCHAR2	(4000)		Type clause of the object view
OID_TEXT_LENGTH	NUMBER			Length of the WITH OBJECT OID clause of the object view
OID_TEXT	VARCHAR2	(4000)		WITH OBJECT OID clause of the object view
VIEW_TYPE_OWNER	VARCHAR2	(128)		Owner of the type of the view if the view is an object view
VIEW_TYPE	VARCHAR2	(128)		Type of the view if the view is an object view
SUPERVIEW_NAME	VARCHAR2	(128)		Name of the superview, if view is a subview
EDITIONING_VIEW	VARCHAR2	(1)		An indicator of whether the view is an Editioning View
READ_ONLY	VARCHAR2	(1)		An indicator of whether the view is a Read Only View
CONTAINER_DATA	VARCHAR2	(1)		An indicator of whether the view contains Container-specific data
BEQUEATH	VARCHAR2	(12)		An indicator of whether the view is invoker rights
ORIGIN_CON_ID	NUMBER			ID of Container where row originates

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      VIEW_NAME
,      TEXT_LENGTH
,      TEXT
,      TEXT_VC
,      TYPE_TEXT_LENGTH
,      TYPE_TEXT
,      OID_TEXT_LENGTH
,      OID_TEXT
,      VIEW_TYPE_OWNER
,      VIEW_TYPE
,      SUPERVIEW_NAME
,      EDITIONING_VIEW
,      READ_ONLY
,      CONTAINER_DATA
,      BEQUEATH
,      ORIGIN_CON_ID
FROM SYS.ALL_VIEWS;

Dependencies

[top of page]

SYS.ALL_VIEWS references the following:

SYS: GETLONG; INT$DBA_VIEWS; OBJAUTH$

SYS.ALL_VIEWS is referenced by following:

PUBLIC: ALL_VIEWS
SYS: ALL_AUDIT_POLICIES; ALL_AUDIT_POLICY_COLUMNS; ALL_POLICIES; ALL_POLICY_ATTRIBUTES; ALL_POLICY_CONTEXTS; ALL_POLICY_GROUPS; ALL_SEC_RELEVANT_COLS; DBMS_CDC_SYS_IPUBLISH - show dependent code; DBMS_DBFS_CONTENT - show dependent code; DBMS_DBFS_SFS - show dependent code