iSelfSchooling.com Since 1999 References | Search more | Oracle Syntax | Free Online Oracle Training

Home .Services Login Start Learning Certification . .Share your BELIEF(s)...

. Online Accounting     .Copyright & User Agreement   |

    .Vision      .Biography     .Acknowledgement
.Contact Us      .Comments/Suggestions       Email2aFriend    |

Complete Syntax | Oracle Functions | PL/SQL Syntax | SQL Syntax | Tables

Oracle Dictionary Tables

ALL_ | DBA_ | USER_ | GV$ | V$ | Others

ALL... | CLU... | IND... | MVI... | PRO... | REP... | SNA... | TAB...

ALL_TAB_COLS: Columns of user's tables, views and clusters

iSelfSchooling-SQL> desc ALL_TAB_COLS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

DATA_TYPE VARCHAR2(106)

DATA_TYPE_MOD VARCHAR2(3)

DATA_TYPE_OWNER VARCHAR2(30)

DATA_LENGTH NOT NULL NUMBER

DATA_PRECISION NUMBER

DATA_SCALE NUMBER

NULLABLE VARCHAR2(1)

COLUMN_ID NUMBER

DEFAULT_LENGTH NUMBER

DATA_DEFAULT LONG

NUM_DISTINCT NUMBER

LOW_VALUE RAW(32)

HIGH_VALUE RAW(32)

DENSITY NUMBER

NUM_NULLS NUMBER

NUM_BUCKETS NUMBER

LAST_ANALYZED DATE

SAMPLE_SIZE NUMBER

CHARACTER_SET_NAME VARCHAR2(44)

CHAR_COL_DECL_LENGTH NUMBER

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

AVG_COL_LEN NUMBER

CHAR_LENGTH NUMBER

CHAR_USED VARCHAR2(1)

V80_FMT_IMAGE VARCHAR2(3)

DATA_UPGRADED VARCHAR2(3)

HIDDEN_COLUMN VARCHAR2(3)

VIRTUAL_COLUMN VARCHAR2(3)

SEGMENT_COLUMN_ID NUMBER

INTERNAL_COLUMN_ID NOT NULL NUMBER

HISTOGRAM VARCHAR2(15)

QUALIFIED_COL_NAME VARCHAR2(4000)

ALL_TAB_COLUMNS: Columns of user's tables, views and clusters

iSelfSchooling-SQL> desc ALL_TAB_COLUMNS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

DATA_TYPE VARCHAR2(106)

DATA_TYPE_MOD VARCHAR2(3)

DATA_TYPE_OWNER VARCHAR2(30)

DATA_LENGTH NOT NULL NUMBER

DATA_PRECISION NUMBER

DATA_SCALE NUMBER

NULLABLE VARCHAR2(1)

COLUMN_ID NUMBER

DEFAULT_LENGTH NUMBER

DATA_DEFAULT LONG

NUM_DISTINCT NUMBER

LOW_VALUE RAW(32)

HIGH_VALUE RAW(32)

DENSITY NUMBER

NUM_NULLS NUMBER

NUM_BUCKETS NUMBER

LAST_ANALYZED DATE

SAMPLE_SIZE NUMBER

CHARACTER_SET_NAME VARCHAR2(44)

CHAR_COL_DECL_LENGTH NUMBER

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

AVG_COL_LEN NUMBER

CHAR_LENGTH NUMBER

CHAR_USED VARCHAR2(1)

V80_FMT_IMAGE VARCHAR2(3)

DATA_UPGRADED VARCHAR2(3)

HISTOGRAM VARCHAR2(15)

ALL_TAB_COL_STATISTICS: Columns of user's tables, views and clusters

iSelfSchooling-SQL> desc ALL_TAB_COL_STATISTICS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(30)

NUM_DISTINCT NUMBER

LOW_VALUE RAW(32)

HIGH_VALUE RAW(32)

DENSITY NUMBER

NUM_NULLS NUMBER

NUM_BUCKETS NUMBER

LAST_ANALYZED DATE

SAMPLE_SIZE NUMBER

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

AVG_COL_LEN NUMBER

HISTOGRAM VARCHAR2(15)

ALL_TAB_COMMENTS: Comments on tables and views accessible to the user

iSelfSchooling-SQL> desc ALL_TAB_COMMENTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

TABLE_TYPE VARCHAR2(11)

COMMENTS VARCHAR2(4000)

ALL_TAB_HISTOGRAMS: Histograms on columns of all tables visible to user

iSelfSchooling-SQL> desc ALL_TAB_HISTOGRAMS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

ENDPOINT_NUMBER NUMBER

ENDPOINT_VALUE NUMBER

ENDPOINT_ACTUAL_VALUE VARCHAR2(1000)

ALL_TAB_MODIFICATIONS: Information regarding modifications to tables

iSelfSchooling-SQL> desc ALL_TAB_MODIFICATIONS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

INSERTS NUMBER

UPDATES NUMBER

DELETES NUMBER

TIMESTAMP DATE

TRUNCATED VARCHAR2(3)

DROP_SEGMENTS NUMBER

ALL_TAB_PARTITIONS

iSelfSchooling-SQL> desc ALL_TAB_PARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COMPOSITE VARCHAR2(3)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_COUNT NUMBER

HIGH_VALUE LONG

HIGH_VALUE_LENGTH NUMBER

PARTITION_POSITION NUMBER

TABLESPACE_NAME VARCHAR2(30)

PCT_FREE NUMBER

PCT_USED NUMBER

INI_TRANS NUMBER

MAX_TRANS NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENT NUMBER

MAX_EXTENT NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

LOGGING VARCHAR2(7)

COMPRESSION VARCHAR2(8)

NUM_ROWS NUMBER

BLOCKS NUMBER

EMPTY_BLOCKS NUMBER

AVG_SPACE NUMBER

CHAIN_CNT NUMBER

AVG_ROW_LEN NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

BUFFER_POOL VARCHAR2(7)

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

ALL_TAB_PRIVS: Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

iSelfSchooling-SQL> desc ALL_TAB_PRIVS;

Name Null? Type

----------------------------- -------- --------------------

GRANTOR NOT NULL VARCHAR2(30)

GRANTEE NOT NULL VARCHAR2(30)

TABLE_SCHEMA NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

HIERARCHY VARCHAR2(3)

ALL_TAB_PRIVS_MADE: User's grants and grants on user's objects

iSelfSchooling-SQL> desc ALL_TAB_PRIVS_MADE;

Name Null? Type

----------------------------- -------- --------------------

GRANTEE NOT NULL VARCHAR2(30)

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

GRANTOR NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

HIERARCHY VARCHAR2(3)

ALL_TAB_PRIVS_RECD: Grants on objects for which the user, PUBLIC or enabled role is the grantee

iSelfSchooling-SQL> desc ALL_TAB_PRIVS_RECD;

Name Null? Type

----------------------------- -------- --------------------

GRANTEE NOT NULL VARCHAR2(30)

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

GRANTOR NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

HIERARCHY VARCHAR2(3)

ALL_TAB_STATISTICS: Optimizer statistics for all tables accessible to the user

iSelfSchooling-SQL> desc ALL_TAB_STATISTICS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

PARTITION_POSITION NUMBER

SUBPARTITION_NAME VARCHAR2(30)

SUBPARTITION_POSITION NUMBER

OBJECT_TYPE VARCHAR2(12)

NUM_ROWS NUMBER

BLOCKS NUMBER

EMPTY_BLOCKS NUMBER

AVG_SPACE NUMBER

CHAIN_CNT NUMBER

AVG_ROW_LEN NUMBER

AVG_SPACE_FREELIST_BLOCKS NUMBER

NUM_FREELIST_BLOCKS NUMBER

AVG_CACHED_BLOCKS NUMBER

AVG_CACHE_HIT_RATIO NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

STATTYPE_LOCKED VARCHAR2(5)

STALE_STATS VARCHAR2(3)

ALL_TAB_STATS_HISTORY: History of table statistics modifications

iSelfSchooling-SQL> desc ALL_TAB_STATS_HISTORY;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

STATS_UPDATE_TIME TIMESTAMP(6)

ALL_TAB_SUBPARTITIONS

iSelfSchooling-SQL> desc ALL_TAB_SUBPARTITIONS;

Name Null? Type

----------------------------- -------- --------------------

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

HIGH_VALUE LONG

HIGH_VALUE_LENGTH NOT NULL NUMBER

SUBPARTITION_POSITION NUMBER

TABLESPACE_NAME NOT NULL VARCHAR2(30)

PCT_FREE NOT NULL NUMBER

PCT_USED NUMBER

INI_TRANS NOT NULL NUMBER

MAX_TRANS NOT NULL NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENT NOT NULL NUMBER

MAX_EXTENT NOT NULL NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

LOGGING VARCHAR2(3)

COMPRESSION VARCHAR2(8)

NUM_ROWS NUMBER

BLOCKS NUMBER

EMPTY_BLOCKS NUMBER

AVG_SPACE NUMBER

CHAIN_CNT NUMBER

AVG_ROW_LEN NUMBER

SAMPLE_SIZE NUMBER

LAST_ANALYZED DATE

BUFFER_POOL VARCHAR2(7)

GLOBAL_STATS VARCHAR2(3)

USER_STATS VARCHAR2(3)

ALL_TRIGGERS: Triggers accessible to the current user

iSelfSchooling-SQL> desc ALL_TRIGGERS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TRIGGER_NAME VARCHAR2(30)

TRIGGER_TYPE VARCHAR2(16)

TRIGGERING_EVENT VARCHAR2(227)

TABLE_OWNER VARCHAR2(30)

BASE_OBJECT_TYPE VARCHAR2(16)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

REFERENCING_NAMES VARCHAR2(128)

WHEN_CLAUSE VARCHAR2(4000)

STATUS VARCHAR2(8)

DESCRIPTION VARCHAR2(4000)

ACTION_TYPE VARCHAR2(11)

TRIGGER_BODY LONG

ALL_TRIGGER_COLS: Column usage in user's triggers or in triggers on user's tables

iSelfSchooling-SQL> desc ALL_TRIGGER_COLS;

Name Null? Type

----------------------------- -------- --------------------

TRIGGER_OWNER VARCHAR2(30)

TRIGGER_NAME VARCHAR2(30)

TABLE_OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

COLUMN_LIST VARCHAR2(3)

COLUMN_USAGE VARCHAR2(17)

ALL_TYPES: Description of types accessible to the user

iSelfSchooling-SQL> desc ALL_TYPES;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TYPE_NAME VARCHAR2(30)

TYPE_OID RAW(16)

TYPECODE VARCHAR2(30)

ATTRIBUTES NUMBER

METHODS NUMBER

PREDEFINED VARCHAR2(3)

INCOMPLETE VARCHAR2(3)

FINAL VARCHAR2(3)

INSTANTIABLE VARCHAR2(3)

SUPERTYPE_OWNER VARCHAR2(30)

SUPERTYPE_NAME VARCHAR2(30)

LOCAL_ATTRIBUTES NUMBER

LOCAL_METHODS NUMBER

TYPEID RAW(16)

ALL_TYPE_ATTRS: Description of attributes of types accessible to the user

iSelfSchooling-SQL> desc ALL_TYPE_ATTRS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TYPE_NAME VARCHAR2(30)

ATTR_NAME VARCHAR2(30)

ATTR_TYPE_MOD VARCHAR2(7)

ATTR_TYPE_OWNER VARCHAR2(30)

ATTR_TYPE_NAME VARCHAR2(30)

LENGTH NUMBER

PRECISION NUMBER

SCALE NUMBER

CHARACTER_SET_NAME VARCHAR2(44)

ATTR_NO NUMBER

INHERITED VARCHAR2(3)

ALL_TYPE_METHODS: Description of methods of types accessible to the user

iSelfSchooling-SQL> desc ALL_TYPE_METHODS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

METHOD_NAME NOT NULL VARCHAR2(30)

METHOD_NO NOT NULL NUMBER

METHOD_TYPE VARCHAR2(6)

PARAMETERS NOT NULL NUMBER

RESULTS NOT NULL NUMBER

FINAL VARCHAR2(3)

INSTANTIABLE VARCHAR2(3)

OVERRIDING VARCHAR2(3)

INHERITED VARCHAR2(3)

ALL_TYPE_VERSIONS: Description of each type version accessible to the user

iSelfSchooling-SQL> desc ALL_TYPE_VERSIONS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

VERSION# NOT NULL NUMBER

TYPECODE VARCHAR2(30)

STATUS VARCHAR2(7)

LINE NOT NULL NUMBER

TEXT VARCHAR2(4000)

HASHCODE RAW(17)

ALL_UNUSED_COL_TABS: All tables with unused columns accessible to the user

iSelfSchooling-SQL> desc ALL_UNUSED_COL_TABS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COUNT NUMBER

ALL_UPDATABLE_COLUMNS: Description of all updatable columns

iSelfSchooling-SQL> desc ALL_UPDATABLE_COLUMNS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

UPDATABLE VARCHAR2(3)

INSERTABLE VARCHAR2(3)

DELETABLE VARCHAR2(3)

ALL_USERS: Information about all users of the database

iSelfSchooling-SQL> desc ALL_USERS;

Name Null? Type

----------------------------- -------- --------------------

USERNAME NOT NULL VARCHAR2(30)

USER_ID NOT NULL NUMBER

CREATED NOT NULL DATE

ALL_USTATS: All statistics

iSelfSchooling-SQL> desc ALL_USTATS;

Name Null? Type

----------------------------- -------- --------------------

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

OBJECT_TYPE VARCHAR2(6)

ASSOCIATION VARCHAR2(8)

COLUMN_NAME VARCHAR2(30)

STATSTYPE_SCHEMA VARCHAR2(30)

STATSTYPE_NAME VARCHAR2(30)

STATISTICS RAW(2000)

ALL_VARRAYS: Description of varrays in tables accessible to the user

iSelfSchooling-SQL> desc ALL_VARRAYS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

PARENT_TABLE_NAME VARCHAR2(30)

PARENT_TABLE_COLUMN VARCHAR2(4000)

TYPE_OWNER VARCHAR2(30)

TYPE_NAME VARCHAR2(30)

LOB_NAME VARCHAR2(30)

STORAGE_SPEC VARCHAR2(30)

RETURN_TYPE VARCHAR2(20)

ELEMENT_SUBSTITUTABLE VARCHAR2(25)

ALL_VIEWS: Description of views accessible to the user

iSelfSchooling-SQL> desc ALL_VIEWS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

VIEW_NAME NOT NULL VARCHAR2(30)

TEXT_LENGTH NUMBER

TEXT LONG

TYPE_TEXT_LENGTH NUMBER

TYPE_TEXT VARCHAR2(4000)

OID_TEXT_LENGTH NUMBER

OID_TEXT VARCHAR2(4000)

VIEW_TYPE_OWNER VARCHAR2(30)

VIEW_TYPE VARCHAR2(30)

SUPERVIEW_NAME VARCHAR2(30)

ALL_WARNING_SETTINGS: Warnings ettings for objects accessible to the user

iSelfSchooling-SQL> desc ALL_WARNING_SETTINGS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

OBJECT_ID NOT NULL NUMBER

OBJECT_TYPE VARCHAR2(12)

WARNING VARCHAR2(40)

SETTING VARCHAR2(7)

ALL_WORKSPACES

iSelfSchooling-SQL> desc ALL_WORKSPACES;

Name Null? Type

----------------------------- -------- --------------------

WORKSPACE VARCHAR2(30)

PARENT_WORKSPACE VARCHAR2(30)

PARENT_SAVEPOINT VARCHAR2(30)

OWNER VARCHAR2(30)

CREATETIME DATE

DESCRIPTION VARCHAR2(1000)

FREEZE_STATUS VARCHAR2(8)

FREEZE_MODE VARCHAR2(20)

FREEZE_WRITER VARCHAR2(30)

FREEZE_OWNER VARCHAR2(30)

SESSION_DURATION VARCHAR2(3)

CURRENT_SESSION VARCHAR2(3)

RESOLVE_STATUS VARCHAR2(8)

RESOLVE_USER VARCHAR2(30)

CONTINUALLY_REFRESHED VARCHAR2(3)

WORKSPACE_LOCKMODE VARCHAR2(19)

WORKSPACE_LOCKMODE_OVERRIDE VARCHAR2(3)

MP_ROOT_WORKSPACE VARCHAR2(30)

ALL_XML_INDEXES: Description of the all XMLType indexes that the user has privileges on

iSelfSchooling-SQL> desc ALL_XML_INDEXES;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

TABLE_OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

PATH_TABLE_NAME NOT NULL VARCHAR2(30)

PATHS XMLTYPE

ALL_XML_SCHEMAS: Description of all XML Schemas that user has privilege to reference

iSelfSchooling-SQL> desc ALL_XML_SCHEMAS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

SCHEMA_URL VARCHAR2(700)

LOCAL VARCHAR2(3)

SCHEMA XMLTYPE

INT_OBJNAME VARCHAR2(4000)

QUAL_SCHEMA_URL VARCHAR2(767)

HIER_TYPE VARCHAR2(11)

ALL_XML_SCHEMAS2: Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column

iSelfSchooling-SQL> desc ALL_XML_SCHEMAS2;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

SCHEMA_URL VARCHAR2(700)

LOCAL VARCHAR2(3)

INT_OBJNAME VARCHAR2(4000)

QUAL_SCHEMA_URL VARCHAR2(767)

ALL_XML_TABLES: Description of the all XMLType tables that the user has privileges on

iSelfSchooling-SQL> desc ALL_XML_TABLES;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

STORAGE_TYPE VARCHAR2(17)

ALL_XML_TAB_COLS: Description of the all XMLType tables that the user has privileges on

iSelfSchooling-SQL> desc ALL_XML_TAB_COLS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

STORAGE_TYPE VARCHAR2(17)

ALL_XML_VIEWS: Description of the all XMLType views that the user has privileges on

iSelfSchooling-SQL> desc ALL_XML_VIEWS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

VIEW_NAME VARCHAR2(30)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

ALL_XML_VIEW_COLS: Description of the all XMLType views that the user has privileges on

iSelfSchooling-SQL> desc ALL_XML_VIEW_COLS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

VIEW_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)