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

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                                  NUMBER

 DIMLA                                  NUMBER

 DIPDB                                  NUMBER

 DIFL2                                  NUMBER

 DIPLID                                 NUMBER

 DIPLN                                  VARCHAR2(101)

 DICUR_SCN                              VARCHAR2(16)

 DIDBUN                                 VARCHAR2(30)

 DIFSTS                                 NUMBER

 DIFOPR                                 NUMBER

 DIFTHS                                 NUMBER

 DIFTGT                                 VARCHAR2(30)

 DIFOBS                                 VARCHAR2(512)

 

DTO$KCVFH: Synonym for DT_$KCVFH

 

iSelfSchooling-SQL> desc DTO$KCVFH;

 Name                          Null?    Type

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

 ADDR                                   RAW(8)

 INDX                                   NUMBER

 INST_ID                                NUMBER

 HXFIL                                  NUMBER

 HXONS                                  NUMBER

 HXSTS                                  VARCHAR2(16)

 HXERR                                  NUMBER

 HXVER                                  NUMBER

 FHSWV                                  NUMBER

 FHCVN                                  NUMBER

 FHDBI                                  NUMBER

 FHDBN                                  VARCHAR2(9)

 FHCSQ                                  NUMBER

 FHFSZ                                  NUMBER

 FHBSZ                                  NUMBER

 FHFNO                                  NUMBER

 FHTYP                                  NUMBER

 FHRDB                                  NUMBER

 FHCRS                                  VARCHAR2(16)

 FHCRT                                  VARCHAR2(20)

 FHRLC                                  VARCHAR2(20)

 FHRLC_I                                NUMBER

 FHRLS                                  VARCHAR2(16)

 FHPRC                                  VARCHAR2(20)

 FHPRC_I                                NUMBER

 FHPRS                                  VARCHAR2(16)

 FHBTI                                  VARCHAR2(20)

 FHBSC                                  VARCHAR2(16)

 FHBTH                                  NUMBER

 FHSTA                                  NUMBER

 FHSCN                                  VARCHAR2(16)

 FHTIM                                  VARCHAR2(20)

 FHTHR                                  NUMBER

 FHRBA_SEQ                              NUMBER

 FHRBA_BNO                              NUMBER

 FHRBA_BOF                              NUMBER

 FHETB                                  RAW(132)

 FHCPC                                  NUMBER

 FHRTS                                  VARCHAR2(20)

 FHCCC                                  NUMBER

 FHBCP_SCN                              VARCHAR2(16)

 FHBCP_TIM                              VARCHAR2(20)

 FHBCP_THR                              NUMBER

 FHBCP_RBA_SEQ                          NUMBER

 FHBCP_RBA_BNO                          NUMBER

 FHBCP_RBA_BOF                          NUMBER

 FHBCP_ETB                              RAW(132)

 FHBHZ                                  NUMBER

 FHXCD                                  RAW(16)

 FHTSN                                  NUMBER

 FHTNM                                  VARCHAR2(30)

 FHRFN                                  NUMBER

 FHAFS                                  VARCHAR2(16)

 FHRFS                                  VARCHAR2(16)

 FHRFT                                  VARCHAR2(20)

 HXIFZ                                  NUMBER

 HXNRCV                                 NUMBER

 HXFNM                                  VARCHAR2(513)

 FHPOFB                                 NUMBER

 FHPNFB                                 NUMBER

 FHPRE10                                NUMBER

 FHFIRSTUNRECSCN                        VARCHAR2(16)

 FHFIRSTUNRECTIME                       VARCHAR2(20)

 HXLMDBA                                NUMBER

 HXLMLD_SCN                             VARCHAR2(16)

 

DUAL

 

iSelfSchooling-SQL> desc DUAL;

 Name                          Null?    Type

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

 DUMMY                                  VARCHAR2(1)

 

GLOBAL_NAME: global database name

 

iSelfSchooling-SQL> desc GLOBAL_NAME;

 Name                          Null?    Type

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

 GLOBAL_NAME                            VARCHAR2(4000)

 

IND: Synonym for USER_INDEXES

 

iSelfSchooling-SQL> desc IND;

 Name                          Null?    Type

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

 INDEX_NAME                    NOT NULL VARCHAR2(30)

 INDEX_TYPE                             VARCHAR2(27)

 TABLE_OWNER                   NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLE_TYPE                             VARCHAR2(11)

 UNIQUENESS                             VARCHAR2(9)

 COMPRESSION                            VARCHAR2(8)

 PREFIX_LENGTH                          NUMBER

 TABLESPACE_NAME                        VARCHAR2(30)

 INI_TRANS                              NUMBER

 MAX_TRANS                              NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                            NUMBER

 MAX_EXTENTS                            NUMBER

 PCT_INCREASE                           NUMBER

 PCT_THRESHOLD                          NUMBER

 INCLUDE_COLUMN                         NUMBER

 FREELISTS                              NUMBER

 FREELIST_GROUPS                        NUMBER

 PCT_FREE                               NUMBER

 LOGGING                                VARCHAR2(3)

 BLEVEL                                 NUMBER

 LEAF_BLOCKS                            NUMBER

 DISTINCT_KEYS                          NUMBER

 AVG_LEAF_BLOCKS_PER_KEY                NUMBER

 AVG_DATA_BLOCKS_PER_KEY                NUMBER

 CLUSTERING_FACTOR                      NUMBER

 STATUS                                 VARCHAR2(8)

 NUM_ROWS                               NUMBER

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 DEGREE                                 VARCHAR2(40)

 INSTANCES                              VARCHAR2(40)

 PARTITIONED                            VARCHAR2(3)

 TEMPORARY                              VARCHAR2(1)

 GENERATED                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 BUFFER_POOL                            VARCHAR2(7)

 USER_STATS                             VARCHAR2(3)

 DURATION                               VARCHAR2(15)

 PCT_DIRECT_ACCESS                      NUMBER

 ITYP_OWNER                             VARCHAR2(30)

 ITYP_NAME                              VARCHAR2(30)

 PARAMETERS                             VARCHAR2(1000)

 GLOBAL_STATS                           VARCHAR2(3)

 DOMIDX_STATUS                          VARCHAR2(12)

 DOMIDX_OPSTATUS                        VARCHAR2(6)

 FUNCIDX_STATUS                         VARCHAR2(8)

 JOIN_INDEX                             VARCHAR2(3)

 IOT_REDUNDANT_PKEY_ELIM                VARCHAR2(3)

 DROPPED                                VARCHAR2(3)

 

INDEX_HISTOGRAM: statistics on keys with repeat count

 

iSelfSchooling-SQL> desc INDEX_HISTOGRAM;

 Name                          Null?    Type

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

 REPEAT_COUNT                           NUMBER

 KEYS_WITH_REPEAT_COUNT                 NUMBER

 

INDEX_STATS: statistics on the b-tree

 

iSelfSchooling-SQL> desc INDEX_STATS;

 Name                          Null?    Type

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

 HEIGHT                                 NUMBER

 BLOCKS                                 NUMBER

 NAME                                   VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 LF_ROWS                                NUMBER

 LF_BLKS                                NUMBER

 LF_ROWS_LEN                            NUMBER

 LF_BLK_LEN                             NUMBER

 BR_ROWS                                NUMBER

 BR_BLKS                                NUMBER

 BR_ROWS_LEN                            NUMBER

 BR_BLK_LEN                             NUMBER

 DEL_LF_ROWS                            NUMBER

 DEL_LF_ROWS_LEN                        NUMBER

 DISTINCT_KEYS                          NUMBER

 MOST_REPEATED_KEY                      NUMBER

 BTREE_SPACE                            NUMBER

 USED_SPACE                             NUMBER

 PCT_USED                               NUMBER

 ROWS_PER_KEY                           NUMBER

 BLKS_GETS_PER_ACCESS                   NUMBER

 PRE_ROWS                               NUMBER

 PRE_ROWS_LEN                           NUMBER

 OPT_CMPR_COUNT                         NUMBER

 OPT_CMPR_PCTSAVE                       NUMBER

 

NLS_DATABASE_PARAMETERS: Permanent NLS parameters of the database

 

iSelfSchooling-SQL> desc NLS_DATABASE_PARAMETERS;

 Name                          Null?    Type

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

 PARAMETER                     NOT NULL VARCHAR2(30)

 VALUE                                  VARCHAR2(40)

 

NLS_INSTANCE_PARAMETERS: NLS parameters of the instance

 

iSelfSchooling-SQL> desc NLS_INSTANCE_PARAMETERS;

 Name                          Null?    Type

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

 PARAMETER                              VARCHAR2(30)

 VALUE                                  VARCHAR2(40)

 

NLS_SESSION_PARAMETERS: NLS parameters of the user session

 

iSelfSchooling-SQL> desc NLS_SESSION_PARAMETERS;

 Name                          Null?    Type

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

 PARAMETER                              VARCHAR2(30)

 VALUE                                  VARCHAR2(40)

 

OBJ: Synonym for USER_OBJECTS

 

iSelfSchooling-SQL> desc OBJ;

 Name                          Null?    Type

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

 OBJECT_NAME                            VARCHAR2(128)

 SUBOBJECT_NAME                         VARCHAR2(30)

 OBJECT_ID                              NUMBER

 DATA_OBJECT_ID                         NUMBER

 OBJECT_TYPE                            VARCHAR2(19)

 CREATED                                DATE

 LAST_DDL_TIME                          DATE

 TIMESTAMP                              VARCHAR2(19)

 STATUS                                 VARCHAR2(7)

 TEMPORARY                              VARCHAR2(1)

 GENERATED                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 

RECYCLEBIN: Synonym for USER_RECYCLEBIN

 

iSelfSchooling-SQL> desc RECYCLEBIN;

 Name                          Null?    Type

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

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 ORIGINAL_NAME                          VARCHAR2(32)

 OPERATION                              VARCHAR2(9)

 TYPE                                   VARCHAR2(25)

 TS_NAME                                VARCHAR2(30)

 CREATETIME                             VARCHAR2(19)

 DROPTIME                               VARCHAR2(19)

 DROPSCN                                NUMBER

 PARTITION_NAME                         VARCHAR2(32)

 CAN_UNDROP                             VARCHAR2(3)

 CAN_PURGE                              VARCHAR2(3)

 RELATED                       NOT NULL NUMBER

 BASE_OBJECT                   NOT NULL NUMBER

 PURGE_OBJECT                  NOT NULL NUMBER

 SPACE                                  NUMBER

 

RESOURCE_COST: Cost for each resource

 

iSelfSchooling-SQL> desc RESOURCE_COST;

 Name                          Null?    Type

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

 RESOURCE_NAME                 NOT NULL VARCHAR2(32)

 UNIT_COST                     NOT NULL NUMBER

 

ROLE_ROLE_PRIVS: Roles which are granted to roles

 

iSelfSchooling-SQL> desc ROLE_ROLE_PRIVS;

 Name                          Null?    Type

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

 ROLE                          NOT NULL VARCHAR2(30)

 GRANTED_ROLE                  NOT NULL VARCHAR2(30)

 ADMIN_OPTION                           VARCHAR2(3)

 

ROLE_SYS_PRIVS: System privileges granted to roles

 

iSelfSchooling-SQL> desc ROLE_SYS_PRIVS;

 Name                          Null?    Type

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

 ROLE                          NOT NULL VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 ADMIN_OPTION                           VARCHAR2(3)

 

ROLE_TAB_PRIVS: Table privileges granted to roles

 

iSelfSchooling-SQL> desc ROLE_TAB_PRIVS;

 Name                          Null?    Type

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

 ROLE                          NOT NULL VARCHAR2(30)

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 GRANTABLE                              VARCHAR2(3)

 

SEQ: Synonym for USER_SEQUENCES

 

iSelfSchooling-SQL> desc SEQ;

 Name                          Null?    Type

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

 SEQUENCE_NAME                 NOT NULL VARCHAR2(30)

 MIN_VALUE                              NUMBER

 MAX_VALUE                              NUMBER

 INCREMENT_BY                  NOT NULL NUMBER

 CYCLE_FLAG                             VARCHAR2(1)

 ORDER_FLAG                             VARCHAR2(1)

 CACHE_SIZE                    NOT NULL NUMBER

 LAST_NUMBER                   NOT NULL NUMBER

 

SESSION_PRIVS: Privileges which the user currently has set

 

iSelfSchooling-SQL> desc SESSION_PRIVS;

 Name                          Null?    Type

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

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 

SESSION_ROLES: Roles which the user currently has enabled.

 

iSelfSchooling-SQL> desc SESSION_ROLES;

 Name                          Null?    Type

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

 ROLE                          NOT NULL VARCHAR2(30)

 

SM$VERSION: Synonym for SM_$VERSION

 

iSelfSchooling-SQL> desc SM$VERSION;

 Name                          Null?    Type

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

 VERSION_TEXT                           CHAR(9)

 VERSION_NUMBER                         NUMBER

 CREATED                                DATE

 

SYN: Synonym for USER_SYNONYMS

 

iSelfSchooling-SQL> desc SYN;

 Name                          Null?    Type

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

 SYNONYM_NAME                  NOT NULL VARCHAR2(30)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 DB_LINK                                VARCHAR2(128)

 

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

 

iSelfSchooling-SQL> desc TABLE_PRIVILEGES;

 Name                          Null?    Type

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

 GRANTEE                       NOT NULL VARCHAR2(30)

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 GRANTOR                       NOT NULL VARCHAR2(30)

 SELECT_PRIV                            VARCHAR2(1)

 INSERT_PRIV                            VARCHAR2(1)

 DELETE_PRIV                            VARCHAR2(1)

 UPDATE_PRIV                            VARCHAR2(1)

 REFERENCES_PRIV                        VARCHAR2(1)

 ALTER_PRIV                             VARCHAR2(1)

 INDEX_PRIV                             VARCHAR2(1)

 CREATED                                VARCHAR2

 

TABS: Synonym for USER_TABLES

 

iSelfSchooling-SQL> desc TABS;

 Name                          Null?    Type

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

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLESPACE_NAME                        VARCHAR2(30)

 CLUSTER_NAME                           VARCHAR2(30)

 IOT_NAME                               VARCHAR2(30)

 STATUS                                 VARCHAR2(8)

 PCT_FREE                               NUMBER

 PCT_USED                               NUMBER

 INI_TRANS                              NUMBER

 MAX_TRANS                              NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                            NUMBER

 MAX_EXTENTS                            NUMBER

 PCT_INCREASE                           NUMBER

 FREELISTS                              NUMBER

 FREELIST_GROUPS                        NUMBER

 LOGGING                                VARCHAR2(3)

 BACKED_UP                              VARCHAR2(1)

 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

 DEGREE                                 VARCHAR2(10)

 INSTANCES                              VARCHAR2(10)

 CACHE                                  VARCHAR2(5)

 TABLE_LOCK                             VARCHAR2(8)

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 PARTITIONED                            VARCHAR2(3)

 IOT_TYPE                               VARCHAR2(12)

 TEMPORARY                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 NESTED                                 VARCHAR2(3)

 BUFFER_POOL                            VARCHAR2(7)

 ROW_MOVEMENT                           VARCHAR2(8)

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 DURATION                               VARCHAR2(15)

 SKIP_CORRUPT                           VARCHAR2(8)

 MONITORING                             VARCHAR2(3)

 CLUSTER_OWNER                          VARCHAR2(30)

 DEPENDENCIES                           VARCHAR2(8)

 COMPRESSION                            VARCHAR2(8)

 DROPPED                                VARCHAR2(3)

 

 

Google
 
Web web site