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_AW_PROP

Object Details

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

Object properties in Analytic Workspaces accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the Analytic Workspace
AW_NUMBER	NUMBER		Yes	Number of the Analytic Workspace
AW_NAME	VARCHAR2	(128)		Name of the Analytic Workspace
OBJ_ID	NUMBER	(20)		Object ID in the Analytic Workspace
OBJ_NAME	VARCHAR2	(256)		Object name in the Analytic Workspace
PROPERTY_NAME	VARCHAR2	(256)		Property name of the object in the Analytic Workspace
PROPERTY_TYPE	VARCHAR2	(4000)		Type of the property in the Analytic Workspace
PROPERTY_VALUE	VARCHAR2	(4000)		Value of the property in the Analytic Workspace
FULL_PROPERTY_VALUE	CLOB	(4000)		Complete value of the property in the Analytic Workspace
PROPERTY_VALUE_LENGTH	NUMBER			Length in bytes of the property in the Analytic Workspace

Query Text

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


SELECT OWNER
,      AW_NUMBER
,      AW_NAME
,      OBJ_ID
,      OBJ_NAME
,      PROPERTY_NAME
,      PROPERTY_TYPE
,      PROPERTY_VALUE
,      FULL_PROPERTY_VALUE
,      PROPERTY_VALUE_LENGTH
FROM SYS.ALL_AW_PROP;

Dependencies

[top of page]

SYS.ALL_AW_PROP references the following:

SYS: AW$; AW_PROP$; DBMS_AW - show dependent code; OBJ$; OBJAUTH$; USER$

SYS.ALL_AW_PROP is referenced by following:

PUBLIC: ALL_AW_PROP