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

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

 

DBA_TAB_STATS_HISTORY: History of table statistics modifications

 

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

 

DBA_TAB_SUBPARTITIONS

 

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

 

DBA_TEMPLATE_REFGROUPS: Table for maintaining refresh group information for template.

 

iSelfSchooling-SQL> desc DBA_TEMPLATE_REFGROUPS;

 Name                          Null?    Type

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

 REFRESH_GROUP_ID              NOT NULL NUMBER

 REFRESH_GROUP_NAME            NOT NULL VARCHAR2(30)

 REFRESH_TEMPLATE_ID           NOT NULL NUMBER

 REFRESH_TEMPLATE_NAME         NOT NULL VARCHAR2(30)

 ROLLBACK_SEG                           VARCHAR2(30)

 START_DATE                             VARCHAR2(200)

 INTERVAL                               VARCHAR2(200)

 

DBA_TEMPLATE_TARGETS: Internal table for tracking potential target databases for templates.

 

iSelfSchooling-SQL> desc DBA_TEMPLATE_TARGETS;

 Name                          Null?    Type

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

 TEMPLATE_TARGET_ID            NOT NULL NUMBER

 TARGET_DATABASE               NOT NULL VARCHAR2(128)

 TARGET_COMMENT                         VARCHAR2(2000)

 CONNECT_STRING                         VARCHAR2(4000)

 

DBA_TEMP_FILES: Information about database temp files

 

iSelfSchooling-SQL> desc DBA_TEMP_FILES;

 Name                          Null?    Type

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

 FILE_NAME                              VARCHAR2(513)

 FILE_ID                                NUMBER

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 STATUS                                 CHAR(9)

 RELATIVE_FNO                           NUMBER

 AUTOEXTENSIBLE                         VARCHAR2(3)

 MAXBYTES                               NUMBER

 MAXBLOCKS                              NUMBER

 INCREMENT_BY                           NUMBER

 USER_BYTES                             NUMBER

 USER_BLOCKS                            NUMBER

 

DBA_THRESHOLDS: Description of all thresholds

 

iSelfSchooling-SQL> desc DBA_THRESHOLDS;

 Name                          Null?    Type

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

 METRICS_NAME                           VARCHAR2(64)

 WARNING_OPERATOR                       VARCHAR2(12)

 WARNING_VALUE                          VARCHAR2(256)

 CRITICAL_OPERATOR                      VARCHAR2(12)

 CRITICAL_VALUE                         VARCHAR2(256)

 OBSERVATION_PERIOD                     NUMBER

 CONSECUTIVE_OCCURRENCES                NUMBER

 INSTANCE_NAME                          VARCHAR2(16)

 OBJECT_TYPE                            VARCHAR2(64)

 OBJECT_NAME                            VARCHAR2(513)

 STATUS                                 VARCHAR2(7)

 

DBA_TRANSFORMATIONS

 

iSelfSchooling-SQL> desc DBA_TRANSFORMATIONS;

 Name                          Null?    Type

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

 TRANSFORMATION_ID             NOT NULL NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 FROM_TYPE                              VARCHAR2(61)

 TO_TYPE                                VARCHAR2(91)

 

DBA_TRIGGERS: All triggers in the database

 

iSelfSchooling-SQL> desc DBA_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

 

DBA_TRIGGER_COLS: Column usage in all triggers

 

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

 

DBA_TSM_DESTINATION: Transparent session migration source session statistics

 

iSelfSchooling-SQL> desc DBA_TSM_DESTINATION;

 Name                          Null?    Type

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

 SOURCE_DATABASE_NAME                   VARCHAR2(4000)

 DESTINATION_DATABASE_NAME              VARCHAR2(4000)

 DESTINATION_INSTANCE_NAME              VARCHAR2(4000)

 DESTINATION_INSTANCE_ID                VARCHAR2(4000)

 DESTINATION_INST_START_TIME            TIMESTAMP(6)

 SEQUENCE#                              NUMBER

 DESTINATION_SID                        NUMBER

 DESTINATION_SERIAL#                    NUMBER

 DESTINATION_START_TIME                 TIMESTAMP(6)

 DESTINATION_END_TIME                   TIMESTAMP(6)

 DESTINATION_USER_NAME         NOT NULL VARCHAR2(30)

 DESTINATION_SCHEMA_NAME       NOT NULL VARCHAR2(30)

 DESTINATION_STATE                      VARCHAR2(24)

 

DBA_TSM_HISTORY: Transparent session migration statistics

 

iSelfSchooling-SQL> desc DBA_TSM_HISTORY;

 Name                          Null?    Type

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

 SEQUENCE#                              NUMBER

 SOURCE_SID                             NUMBER

 SOURCE_SERIAL#                         NUMBER

 USER_NAME                     NOT NULL VARCHAR2(30)

 SCHEMA_NAME                   NOT NULL VARCHAR2(30)

 STATE                                  VARCHAR2(24)

 COST                                   NUMBER

 SOURCE                                 VARCHAR2(4000)

 SOURCE_INSTANCE_ID                     VARCHAR2(4000)

 SOURCE_START_TIME                      TIMESTAMP(6)

 CONNECT_STRING                         VARCHAR2(4000)

 FAILURE_REASON                         VARCHAR2(34)

 DESTINATION_SID                        NUMBER

 DESTINATION_SERIAL#                    NUMBER

 DESTINATION_STATE                      VARCHAR2(24)

 DESTINATION                            VARCHAR2(4000)

 DESTINATION_INSTANCE_ID                VARCHAR2(4000)

 DESTINATION_START_TIME                 TIMESTAMP(6)

 ROUNDTRIPS                             NUMBER

 START_TIME                             TIMESTAMP(6)

 END_TIME                               TIMESTAMP(6)

 

DBA_TSM_SOURCE: Transparent session migration source session statistics

 

iSelfSchooling-SQL> desc DBA_TSM_SOURCE;

 Name                          Null?    Type

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

 SOURCE_DATABASE_NAME                   VARCHAR2(4000)

 SOURCE_INSTANCE_NAME                   VARCHAR2(4000)

 SOURCE_INSTANCE_ID                     VARCHAR2(4000)

 SOURCE_INSTANCE_START_TIME             TIMESTAMP(6)

 SEQUENCE#                              NUMBER

 SOURCE_SID                             NUMBER

 SOURCE_SERIAL#                         NUMBER

 SOURCE_STATE                           VARCHAR2(24)

 CONNECT_STRING                         VARCHAR2(4000)

 SOURCE_START_TIME                      TIMESTAMP(6)

 COST                                   NUMBER

 FAILURE_REASON                         VARCHAR2(34)

 SOURCE_END_TIME                        TIMESTAMP(6)

 ROUNDTRIPS                             NUMBER

 SOURCE_USER_NAME              NOT NULL VARCHAR2(30)

 SOURCE_SCHEMA_NAME            NOT NULL VARCHAR2(30)

 DESTINATION_DATABASE_NAME              VARCHAR2(4000)

 

DBA_TS_QUOTAS: Tablespace quotas for all users

 

iSelfSchooling-SQL> desc DBA_TS_QUOTAS;

 Name                          Null?    Type

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

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 USERNAME                      NOT NULL VARCHAR2(30)

 BYTES                                  NUMBER

 MAX_BYTES                              NUMBER

 BLOCKS                                 NUMBER

 MAX_BLOCKS                             NUMBER

 DROPPED                                VARCHAR2(3)

 

DBA_TUNE_MVIEW: Catalog View to show the result after executing TUNE_MVIEW() API

 

iSelfSchooling-SQL> desc DBA_TUNE_MVIEW;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TASK_NAME                              VARCHAR2(30)

 ACTION_ID                     NOT NULL NUMBER

 SCRIPT_TYPE                            VARCHAR2(14)

 STATEMENT                              CLOB

 

DBA_TYPES: Description of all types in the database

 

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

 

DBA_TYPE_ATTRS: Description of attributes of all types in the database

 

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

 

DBA_TYPE_METHODS: Description of methods of all types in the database

 

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

 

DBA_TYPE_VERSIONS: Description of each type version in the database

 

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

 

DBA_UNDO_EXTENTS: Extents comprising all segments in the system managed undo tablespaces

 

iSelfSchooling-SQL> desc DBA_UNDO_EXTENTS;

 Name                          Null?    Type

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

 OWNER                                  CHAR(3)

 SEGMENT_NAME                  NOT NULL VARCHAR2(30)

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 EXTENT_ID                              NUMBER

 FILE_ID                       NOT NULL NUMBER

 BLOCK_ID                               NUMBER

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 RELATIVE_FNO                           NUMBER

 COMMIT_JTIME                           NUMBER

 COMMIT_WTIME                           VARCHAR2(20)

 STATUS                                 VARCHAR2(9)

 

DBA_UNUSED_COL_TABS: All tables with unused columns in the database

 

iSelfSchooling-SQL> desc DBA_UNUSED_COL_TABS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 COUNT                                  NUMBER

 

DBA_UPDATABLE_COLUMNS: Description of dba updatable columns

 

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

 

DBA_USERS: Information about all users of the database

 

iSelfSchooling-SQL> desc DBA_USERS;

 Name                          Null?    Type

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

 USERNAME                      NOT NULL VARCHAR2(30)

 USER_ID                       NOT NULL NUMBER

 PASSWORD                               VARCHAR2(30)

 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

 PROFILE                       NOT NULL VARCHAR2(30)

 INITIAL_RSRC_CONSUMER_GROUP            VARCHAR2(30)

 EXTERNAL_NAME                          VARCHAR2(4000)

 

DBA_USTATS: All statistics collected on either tables or indexes

 

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

 

DBA_VARRAYS: Description of varrays in tables accessible to the user

 

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

 

DBA_VIEWS: Description of all views in the database

 

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

 

DBA_WAITERS

 

iSelfSchooling-SQL> desc DBA_WAITERS;

 Name                          Null?    Type

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

 WAITING_SESSION                        NUMBER

 HOLDING_SESSION                        NUMBER

 LOCK_TYPE                              VARCHAR2(26)

 MODE_HELD                              VARCHAR2(40)

 MODE_REQUESTED                         VARCHAR2(40)

 LOCK_ID1                               NUMBER

 LOCK_ID2                               NUMBER

 

DBA_WARNING_SETTINGS: warning settings for all objects

 

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

 

DBA_WORKSPACES

 

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

 SID                                    VARCHAR2(30)

 SERIAL#                                VARCHAR2(30)

 FREEZE_OWNER                           VARCHAR2(30)

 SESSION_DURATION                       VARCHAR2(3)

 CURRENT_SESSION                        VARCHAR2(3)

 RESOLVE_STATUS                         VARCHAR2(8)

 RESOLVE_USER                           VARCHAR2(30)

 MP_ROOT_WORKSPACE                      VARCHAR2(30)

 

DBA_WORKSPACE_SESSIONS

 

iSelfSchooling-SQL> desc DBA_WORKSPACE_SESSIONS;

 Name                          Null?    Type

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

 USERNAME                               VARCHAR2(30)

 WORKSPACE                     NOT NULL VARCHAR2(30)

 SID                                    NUMBER

 STATUS                                 VARCHAR2(8)

 

DBA_XML_INDEXES: Description of all XML indexes in the database

 

iSelfSchooling-SQL> desc DBA_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

 

DBA_XML_SCHEMAS: Description of all the XML Schemas registered

 

iSelfSchooling-SQL> desc DBA_XML_SCHEMAS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 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)

 

DBA_XML_TABLES: Description of all XML tables in the database

 

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

 

DBA_XML_TAB_COLS: Description of all XML tables in the database

 

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

 

DBA_XML_VIEWS: Description of all XML views in the database

 

iSelfSchooling-SQL> desc DBA_XML_VIEWS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 VIEW_NAME                              VARCHAR2(30)

 XMLSCHEMA                              VARCHAR2(700)

 SCHEMA_OWNER                           VARCHAR2(30)

 ELEMENT_NAME                           VARCHAR2(2000)

 

DBA_XML_VIEW_COLS: Description of all XML views in the database

 

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

 

 

 

Google
 
Web web site