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

ADV... | AUD... | FIL... | LOB... | PAR... | REP... | SEQ... | TAB...

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

iSelfSchooling-SQL> desc USER_TAB_COLS;

Name Null? Type

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

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)

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

iSelfSchooling-SQL> desc USER_TAB_COLUMNS;

Name Null? Type

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

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)

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

iSelfSchooling-SQL> desc USER_TAB_COL_STATISTICS;

Name Null? Type

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

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)

USER_TAB_COMMENTS: Comments on the tables and views owned by the user

iSelfSchooling-SQL> desc USER_TAB_COMMENTS;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

TABLE_TYPE VARCHAR2(11)

COMMENTS VARCHAR2(4000)

USER_TAB_HISTOGRAMS: Histograms on columns of user's tables

iSelfSchooling-SQL> desc USER_TAB_HISTOGRAMS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

ENDPOINT_NUMBER NUMBER

ENDPOINT_VALUE NUMBER

ENDPOINT_ACTUAL_VALUE VARCHAR2(1000)

USER_TAB_MODIFICATIONS: Information regarding modifications to tables

iSelfSchooling-SQL> desc USER_TAB_MODIFICATIONS;

Name Null? Type

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

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

USER_TAB_PARTITIONS

iSelfSchooling-SQL> desc USER_TAB_PARTITIONS;

Name Null? Type

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

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)

USER_TAB_PRIVS: Grants on objects for which the user is the owner, grantor or grantee

iSelfSchooling-SQL> desc USER_TAB_PRIVS;

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)

USER_TAB_PRIVS_MADE: All grants on objects owned by the user

iSelfSchooling-SQL> desc USER_TAB_PRIVS_MADE;

Name Null? Type

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

GRANTEE 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)

USER_TAB_PRIVS_RECD: Grants on objects for which the user is the grantee

iSelfSchooling-SQL> desc USER_TAB_PRIVS_RECD;

Name Null? Type

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

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)

USER_TAB_STATISTICS: Optimizer statistics of the user's own tables

iSelfSchooling-SQL> desc USER_TAB_STATISTICS;

Name Null? Type

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

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)

USER_TAB_STATS_HISTORY: History of table statistics modifications

iSelfSchooling-SQL> desc USER_TAB_STATS_HISTORY;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

PARTITION_NAME VARCHAR2(30)

SUBPARTITION_NAME VARCHAR2(30)

STATS_UPDATE_TIME TIMESTAMP(6)

USER_TAB_SUBPARTITIONS

iSelfSchooling-SQL> desc USER_TAB_SUBPARTITIONS;

Name Null? Type

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

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)

USER_TRANSFORMATIONS

iSelfSchooling-SQL> desc USER_TRANSFORMATIONS;

Name Null? Type

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

TRANSFORMATION_ID NOT NULL NUMBER

NAME NOT NULL VARCHAR2(30)

FROM_TYPE VARCHAR2(61)

TO_TYPE VARCHAR2(91)

USER_TRIGGERS: Triggers owned by the user

iSelfSchooling-SQL> desc USER_TRIGGERS;

Name Null? Type

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

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

USER_TRIGGER_COLS: Column usage in user's triggers

iSelfSchooling-SQL> desc USER_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)

USER_TS

iSelfSchooling-SQL> desc USER_TS;

Name Null? Type

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

UNAME NOT NULL VARCHAR2(30)

TSNAME NOT NULL VARCHAR2(30)

TSN NOT NULL NUMBER

USER_TS_QUOTAS: Tablespace quotas for the user

iSelfSchooling-SQL> desc USER_TS_QUOTAS;

Name Null? Type

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

TABLESPACE_NAME NOT NULL VARCHAR2(30)

BYTES NUMBER

MAX_BYTES NUMBER

BLOCKS NUMBER

MAX_BLOCKS NUMBER

DROPPED VARCHAR2(3)

USER_TUNE_MVIEW: tune_mview catalog view owned by the user

iSelfSchooling-SQL> desc USER_TUNE_MVIEW;

Name Null? Type

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

TASK_NAME VARCHAR2(30)

ACTION_ID NOT NULL NUMBER

SCRIPT_TYPE VARCHAR2(14)

STATEMENT CLOB

USER_TYPES: Description of the user's own types

iSelfSchooling-SQL> desc USER_TYPES;

Name Null? Type

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

TYPE_NAME NOT NULL VARCHAR2(30)

TYPE_OID NOT NULL 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)

USER_TYPE_ATTRS: Description of attributes of the user's own types

iSelfSchooling-SQL> desc USER_TYPE_ATTRS;

Name Null? Type

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

TYPE_NAME NOT NULL VARCHAR2(30)

ATTR_NAME NOT NULL 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 NOT NULL NUMBER

INHERITED VARCHAR2(3)

USER_TYPE_METHODS: Description of methods of the user's own types

iSelfSchooling-SQL> desc USER_TYPE_METHODS;

Name Null? Type

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

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)

USER_TYPE_VERSIONS: Description of each version of the user's types

iSelfSchooling-SQL> desc USER_TYPE_VERSIONS;

Name Null? Type

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

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)

USER_UNUSED_COL_TABS: User tables with unused columns

iSelfSchooling-SQL> desc USER_UNUSED_COL_TABS;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

COUNT NUMBER

USER_UPDATABLE_COLUMNS: Description of updatable columns

iSelfSchooling-SQL> desc USER_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)

USER_USERS: Information about the current user

iSelfSchooling-SQL> desc USER_USERS;

Name Null? Type

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

USERNAME NOT NULL VARCHAR2(30)

USER_ID NOT NULL NUMBER

ACCOUNT_STATUS NOT NULL VARCHAR2(32)

LOCK_DATE DATE

EXPIRY_DATE DATE

DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)

TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)

CREATED NOT NULL DATE

INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)

EXTERNAL_NAME VARCHAR2(4000)

USER_USTATS: All statistics on tables or indexes owned by the user

iSelfSchooling-SQL> desc USER_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)

USER_VARRAYS: Description of varrays contained in the user's own tables

iSelfSchooling-SQL> desc USER_VARRAYS;

Name Null? Type

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

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)

USER_VIEWS: Description of the user's own views

iSelfSchooling-SQL> desc USER_VIEWS;

Name Null? Type

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

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)

USER_WARNING_SETTINGS: Warning Parameter settings for objects owned by the user

iSelfSchooling-SQL> desc USER_WARNING_SETTINGS;

Name Null? Type

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

OBJECT_NAME NOT NULL VARCHAR2(30)

OBJECT_ID NOT NULL NUMBER

OBJECT_TYPE VARCHAR2(12)

WARNING VARCHAR2(40)

SETTING VARCHAR2(7)

USER_WORKSPACES

iSelfSchooling-SQL> desc USER_WORKSPACES;

Name Null? Type

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

WORKSPACE NOT NULL 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)

USER_XML_COLUMN_NAMES

iSelfSchooling-SQL> desc USER_XML_COLUMN_NAMES;

Name Null? Type

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

SCHEMA_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

OBJECT_COLUMN_NAME VARCHAR2(30)

EXTERNAL_COLUMN_NAME VARCHAR2(30)

USER_XML_INDEXES: Description of the user's own XMLType indexes

iSelfSchooling-SQL> desc USER_XML_INDEXES;

Name Null? Type

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

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

USER_XML_SCHEMAS: Description of XML Schemas registered by the user

iSelfSchooling-SQL> desc USER_XML_SCHEMAS;

Name Null? Type

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

SCHEMA_URL VARCHAR2(700)

LOCAL VARCHAR2(3)

SCHEMA XMLTYPE(XMLSchema "h

ttp://xmlns.oracle.c

om/xdb/XDBSchema.xsd

" Element "schema")

INT_OBJNAME VARCHAR2(4000)

QUAL_SCHEMA_URL VARCHAR2(767)

HIER_TYPE VARCHAR2(11)

USER_XML_TABLES: Description of the user's own XMLType tables

iSelfSchooling-SQL> desc USER_XML_TABLES;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

STORAGE_TYPE VARCHAR2(17)

USER_XML_TAB_COLS: Description of the user's own XMLType tables

iSelfSchooling-SQL> desc USER_XML_TAB_COLS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

STORAGE_TYPE VARCHAR2(17)

USER_XML_VIEWS: Description of the user's own XMLType views

iSelfSchooling-SQL> desc USER_XML_VIEWS;

Name Null? Type

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

VIEW_NAME VARCHAR2(30)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)

USER_XML_VIEW_COLS: Description of the user's own XMLType views

iSelfSchooling-SQL> desc USER_XML_VIEW_COLS;

Name Null? Type

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

VIEW_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

XMLSCHEMA VARCHAR2(700)

SCHEMA_OWNER VARCHAR2(30)

ELEMENT_NAME VARCHAR2(2000)