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