|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
AUD...
AUDIT_ACTIONS: Description table for audit trail action type
codes. Maps action type
numbers to action type names
iSelfSchooling-SQL> desc AUDIT_ACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
ACTION
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(28)
CAT: Synonym for USER_CATALOG
iSelfSchooling-SQL> desc CAT;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
CLU: Synonym for USER_CLUSTERS
iSelfSchooling-SQL> desc CLU;
Name
Null? Type
----------------------------- -------- --------------------
CLUSTER_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
KEY_SIZE
NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
AVG_BLOCKS_PER_KEY
NUMBER
CLUSTER_TYPE
VARCHAR2(5)
FUNCTION
VARCHAR2(15)
HASHKEYS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
BUFFER_POOL
VARCHAR2(7)
SINGLE_TABLE
VARCHAR2(5)
DEPENDENCIES
VARCHAR2(8)
COLS: Synonym for USER_TAB_COLUMNS
iSelfSchooling-SQL> desc 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)
HISTOGRAM
VARCHAR2(15)
COLUMN_PRIVILEGES: Grants on columns for which the user is the
grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc COLUMN_PRIVILEGES;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
INSERT_PRIV
VARCHAR2(1)
UPDATE_PRIV
VARCHAR2(1)
REFERENCES_PRIV
VARCHAR2(1)
CREATED
VARCHAR2
DATABASE_COMPATIBLE_LEVEL: Database compatible parameter set via init.ora
iSelfSchooling-SQL> desc DATABASE_COMPATIBLE_LEVEL;
Name
Null? Type
----------------------------- -------- --------------------
VALUE
VARCHAR2(512)
DESCRIPTION
VARCHAR2(255)
DBMS_ALERT_INFO
iSelfSchooling-SQL> desc DBMS_ALERT_INFO;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
SID
NOT NULL VARCHAR2(30)
CHANGED
VARCHAR2(1)
MESSAGE
VARCHAR2(1800)
DBMS_LOCK_ALLOCATED
iSelfSchooling-SQL> desc DBMS_LOCK_ALLOCATED;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(128)
LOCKID
NUMBER(38)
EXPIRATION
DATE
DICT: Synonym for DICTIONARY
iSelfSchooling-SQL> desc DICT;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COMMENTS VARCHAR2(4000)
DICTIONARY: Description of data dictionary tables and views
iSelfSchooling-SQL> desc DICTIONARY;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DICT_COLUMNS: Description of columns in data dictionary tables
and views
iSelfSchooling-SQL> desc DICT_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DTO$KCCDI: Synonym for DT_$KCCDI
iSelfSchooling-SQL> desc DTO$KCCDI;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
INDX
NUMBER
INST_ID
NUMBER
DIDFV
NUMBER
DIDFC
NUMBER
DICTS
VARCHAR2(20)
DIDBN
VARCHAR2(9)
DIRDB
NUMBER
DICCT
VARCHAR2(20)
DIFLG
NUMBER
DIIRS
VARCHAR2(16)
DIRLS
VARCHAR2(16)
DIRLC
VARCHAR2(20)
DIRLC_I
NUMBER
DIPRS
VARCHAR2(16)
DIPRC
VARCHAR2(20)
DIPRC_I
NUMBER
DIRDV
NUMBER
DIRDC
NUMBER
DINDF
NUMBER
DINTF
NUMBER
DINOF
NUMBER
DICPT
NUMBER
DISCN
VARCHAR2(16)
DINET
NUMBER
DINOT
NUMBER
DIOTH
NUMBER
DIOTT
NUMBER
DIETB
RAW(132)
DIMLM
NUMBER
DIMDM
NUMBER
DIARH
NUMBER
DIART
NUMBER
DIPRT
NUMBER
DIFAS
VARCHAR2(16)
DICKP_SCN
VARCHAR2(16)
DICKP_TIM
VARCHAR2(20)
DICSQ
NUMBER
DIDBI
NUMBER
DISSC_SCN
VARCHAR2(16)
DISSC_TIM
VARCHAR2(20)
DISFP
NUMBER
DIBSC
NUMBER
DIPOFB
NUMBER
DIPNFB
NUMBER
DICOFB
NUMBER
DICNFB
NUMBER
DIVTS
VARCHAR2(20)
DICID
NUMBER
DIDOR
NUMBER
DISLH
NUMBER
DISLT
NUMBER
DIRAE
NUMBER
DIACID
NUMBER
DIARS
VARCHAR2(16)
DISOS
NUMBER
DIDGD |