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: XDB.JSON$COLLECTION_METADATA_V

Object Details

Object Name:	JSON$COLLECTION_METADATA_V
Object Type:	VIEW
Owner:	XDB
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
URI_NAME	NVARCHAR2	(510)	Yes
OWNER	VARCHAR2	(128)	Yes
SCHEMA_NAME	VARCHAR2	(128)
TABLE_NAME	VARCHAR2	(128)
VIEW_NAME	VARCHAR2	(128)
PACKAGE_NAME	VARCHAR2	(128)
KEY_COLUMN_NAME	VARCHAR2	(128)
KEY_COLUMN_TYPE	VARCHAR2	(10)
KEY_COLUMN_LEN	NUMBER
KEY_ASSIGNMENT_METHOD	VARCHAR2	(10)
KEY_SEQUENCE_NAME	VARCHAR2	(128)
CONTENT_COLUMN_NAME	VARCHAR2	(128)
CONTENT_COLUMN_TYPE	VARCHAR2	(10)
CONTENT_COLUMN_LEN	NUMBER
CONTENT_VALIDATION	VARCHAR2	(10)
CONTENT_LOB_COMPRESS	VARCHAR2	(10)
CONTENT_LOB_CACHE	VARCHAR2	(10)
CONTENT_LOB_ENCRYPT	VARCHAR2	(10)
LAST_MODIFIED_COLUMN_NAME	VARCHAR2	(128)
LAST_MODIFIED_INDEX	VARCHAR2	(128)
VERSION_COLUMN_NAME	VARCHAR2	(128)
VERSIONING_METHOD	VARCHAR2	(10)
MEDIA_TYPE_COLUMN_NAME	VARCHAR2	(128)
CREATION_TIME_COLUMN_NAME	VARCHAR2	(128)
READ_ONLY	VARCHAR2	(10)

Query Text

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


SELECT URI_NAME
,      OWNER
,      SCHEMA_NAME
,      TABLE_NAME
,      VIEW_NAME
,      PACKAGE_NAME
,      KEY_COLUMN_NAME
,      KEY_COLUMN_TYPE
,      KEY_COLUMN_LEN
,      KEY_ASSIGNMENT_METHOD
,      KEY_SEQUENCE_NAME
,      CONTENT_COLUMN_NAME
,      CONTENT_COLUMN_TYPE
,      CONTENT_COLUMN_LEN
,      CONTENT_VALIDATION
,      CONTENT_LOB_COMPRESS
,      CONTENT_LOB_CACHE
,      CONTENT_LOB_ENCRYPT
,      LAST_MODIFIED_COLUMN_NAME
,      LAST_MODIFIED_INDEX
,      VERSION_COLUMN_NAME
,      VERSIONING_METHOD
,      MEDIA_TYPE_COLUMN_NAME
,      CREATION_TIME_COLUMN_NAME
,      READ_ONLY
FROM XDB.JSON$COLLECTION_METADATA_V;

Dependencies

[top of page]

XDB.JSON$COLLECTION_METADATA_V references the following:

XDB: JSON$COLLECTION_METADATA

XDB.JSON$COLLECTION_METADATA_V is not referenced by any database object