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_OPANCILLARY: All ancillary operators

 

iSelfSchooling-SQL> desc DBA_OPANCILLARY;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 PRIMOP_OWNER                  NOT NULL VARCHAR2(30)

 PRIMOP_NAME                   NOT NULL VARCHAR2(30)

 PRIMOP_BIND#                  NOT NULL NUMBER

 

DBA_OPARGUMENTS: All operator arguments

 

iSelfSchooling-SQL> desc DBA_OPARGUMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 POSITION                      NOT NULL NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 

DBA_OPBINDINGS: All operator binding functiosn or methods

 

iSelfSchooling-SQL> desc DBA_OPBINDINGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 BINDING#                      NOT NULL NUMBER

 FUNCTION_NAME                          VARCHAR2(92)

 RETURN_SCHEMA                          VARCHAR2(30)

 RETURN_TYPE                            VARCHAR2(30)

 IMPLEMENTATION_TYPE_SCHEMA             VARCHAR2(30)

 IMPLEMENTATION_TYPE                    VARCHAR2(30)

 PROPERTY                               VARCHAR2(43)

 

DBA_OPERATORS: All operators

 

iSelfSchooling-SQL> desc DBA_OPERATORS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 NUMBER_OF_BINDS               NOT NULL NUMBER

 

DBA_OPERATOR_COMMENTS: Comments for user-defined operators

 

iSelfSchooling-SQL> desc DBA_OPERATOR_COMMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 COMMENTS                               VARCHAR2(4000)

 

DBA_OPTSTAT_OPERATIONS: History of statistics operations performed

 

iSelfSchooling-SQL> desc DBA_OPTSTAT_OPERATIONS;

 Name                          Null?    Type

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

 OPERATION                              VARCHAR2(64)

 TARGET                                 VARCHAR2(64)

 START_TIME                             TIMESTAMP(6)

 END_TIME                               TIMESTAMP(6)

 

DBA_OUTLINES: Stored outlines

 

iSelfSchooling-SQL> desc DBA_OUTLINES;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 OWNER                                  VARCHAR2(30)

 CATEGORY                               VARCHAR2(30)

 USED                                   VARCHAR2(6)

 TIMESTAMP                              DATE

 VERSION                                VARCHAR2(64)

 SQL_TEXT                               LONG

 SIGNATURE                              RAW(16)

 COMPATIBLE                             VARCHAR2(12)

 ENABLED                                VARCHAR2(8)

 FORMAT                                 VARCHAR2(6)

 

DBA_OUTLINE_HINTS: Hints stored in outlines

 

iSelfSchooling-SQL> desc DBA_OUTLINE_HINTS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 OWNER                                  VARCHAR2(30)

 NODE                                   NUMBER

 STAGE                                  NUMBER

 JOIN_POS                               NUMBER

 HINT                                   CLOB

 

DBA_OUTSTANDING_ALERTS: Description of all outstanding alerts

 

iSelfSchooling-SQL> desc DBA_OUTSTANDING_ALERTS;

 Name                          Null?    Type

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

 SEQUENCE_ID                            NUMBER

 REASON_ID                     NOT NULL NUMBER

 OWNER                                  VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(513)

 SUBOBJECT_NAME                         VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(64)

 REASON                                 VARCHAR2(4000)

 TIME_SUGGESTED                         TIMESTAMP(6)

 CREATION_TIME                          TIMESTAMP(6)

 SUGGESTED_ACTION                       VARCHAR2(4000)

 ADVISOR_NAME                           VARCHAR2(30)

 METRIC_VALUE                           NUMBER

 MESSAGE_TYPE                           VARCHAR2(12)

 MESSAGE_GROUP                          VARCHAR2(64)

 MESSAGE_LEVEL                          NUMBER

 HOSTING_CLIENT_ID                      VARCHAR2(64)

 MODULE_ID                              VARCHAR2(64)

 PROCESS_ID                             VARCHAR2(128)

 HOST_ID                                VARCHAR2(256)

 HOST_NW_ADDR                           VARCHAR2(256)

 INSTANCE_NAME                          VARCHAR2(16)

 INSTANCE_NUMBER                        NUMBER

 USER_ID                                VARCHAR2(30)

 EXECUTION_CONTEXT_ID                   VARCHAR2(60)

 ERROR_INSTANCE_ID                      VARCHAR2(142)

 

DBA_PARTIAL_DROP_TABS: All tables with partially dropped columns in the database

 

iSelfSchooling-SQL> desc DBA_PARTIAL_DROP_TABS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

DBA_PART_COL_STATISTICS

 

iSelfSchooling-SQL> desc DBA_PART_COL_STATISTICS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 NUM_DISTINCT                           NUMBER

 LOW_VALUE                              RAW(32)

 HIGH_VALUE                             RAW(32)

 DENSITY                                NUMBER

 NUM_NULLS                              NUMBER

 NUM_BUCKETS                            NUMBER

 SAMPLE_SIZE                            NUMBER

 LAST_ANALYZED                          DATE

 GLOBAL_STATS                           VARCHAR2(3)

 USER_STATS                             VARCHAR2(3)

 AVG_COL_LEN                            NUMBER

 HISTOGRAM                              VARCHAR2(15)

 

DBA_PART_HISTOGRAMS

 

iSelfSchooling-SQL> desc DBA_PART_HISTOGRAMS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 PARTITION_NAME                         VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 BUCKET_NUMBER                          NUMBER

 ENDPOINT_VALUE                         NUMBER

 ENDPOINT_ACTUAL_VALUE                  VARCHAR2(1000)

 

DBA_PART_INDEXES

 

iSelfSchooling-SQL> desc DBA_PART_INDEXES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 INDEX_NAME                    NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 PARTITIONING_TYPE                      VARCHAR2(7)

 SUBPARTITIONING_TYPE                   VARCHAR2(7)

 PARTITION_COUNT               NOT NULL NUMBER

 DEF_SUBPARTITION_COUNT                 NUMBER

 PARTITIONING_KEY_COUNT        NOT NULL NUMBER

 SUBPARTITIONING_KEY_COUNT              NUMBER

 LOCALITY                               VARCHAR2(6)

 ALIGNMENT                              VARCHAR2(12)

 DEF_TABLESPACE_NAME                    VARCHAR2(30)

 DEF_PCT_FREE                  NOT NULL NUMBER

 DEF_INI_TRANS                 NOT NULL NUMBER

 DEF_MAX_TRANS                 NOT NULL NUMBER

 DEF_INITIAL_EXTENT                     VARCHAR2(40)

 DEF_NEXT_EXTENT                        VARCHAR2(40)

 DEF_MIN_EXTENTS                        VARCHAR2(40)

 DEF_MAX_EXTENTS                        VARCHAR2(40)

 DEF_PCT_INCREASE                       VARCHAR2(40)

 DEF_FREELISTS                 NOT NULL NUMBER

 DEF_FREELIST_GROUPS           NOT NULL NUMBER

 DEF_LOGGING                            VARCHAR2(7)

 DEF_BUFFER_POOL                        VARCHAR2(7)

 DEF_PARAMETERS                         VARCHAR2(1000)

 

DBA_PART_KEY_COLUMNS

 

iSelfSchooling-SQL> desc DBA_PART_KEY_COLUMNS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 NAME                                   VARCHAR2(30)

 OBJECT_TYPE                            CHAR(5)

 COLUMN_NAME                            VARCHAR2(4000)

 COLUMN_POSITION                        NUMBER

 

DBA_PART_LOBS

 

iSelfSchooling-SQL> desc DBA_PART_LOBS;

 Name                          Null?    Type

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

 TABLE_OWNER                   NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 LOB_NAME                      NOT NULL VARCHAR2(30)

 LOB_INDEX_NAME                NOT NULL VARCHAR2(30)

 DEF_CHUNK                     NOT NULL NUMBER

 DEF_PCTVERSION                NOT NULL NUMBER

 DEF_CACHE                              VARCHAR2(10)

 DEF_IN_ROW                             VARCHAR2(3)

 DEF_TABLESPACE_NAME                    VARCHAR2(30)

 DEF_INITIAL_EXTENT                     VARCHAR2(40)

 DEF_NEXT_EXTENT                        VARCHAR2(40)

 DEF_MIN_EXTENTS                        VARCHAR2(40)

 DEF_MAX_EXTENTS                        VARCHAR2(40)

 DEF_PCT_INCREASE                       VARCHAR2(40)

 DEF_FREELISTS                          VARCHAR2(40)

 DEF_FREELIST_GROUPS                    VARCHAR2(40)

 DEF_LOGGING                            VARCHAR2(7)

 DEF_BUFFER_POOL                        VARCHAR2(7)

 

DBA_PART_TABLES

 

iSelfSchooling-SQL> desc DBA_PART_TABLES;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 PARTITIONING_TYPE                      VARCHAR2(7)

 SUBPARTITIONING_TYPE                   VARCHAR2(7)

 PARTITION_COUNT                        NUMBER

 DEF_SUBPARTITION_COUNT                 NUMBER

 PARTITIONING_KEY_COUNT                 NUMBER

 SUBPARTITIONING_KEY_COUNT              NUMBER

 STATUS                                 VARCHAR2(8)

 DEF_TABLESPACE_NAME                    VARCHAR2(30)

 DEF_PCT_FREE                           NUMBER

 DEF_PCT_USED                           NUMBER

 DEF_INI_TRANS                          NUMBER

 DEF_MAX_TRANS                          NUMBER

 DEF_INITIAL_EXTENT                     VARCHAR2(40)

 DEF_NEXT_EXTENT                        VARCHAR2(40)

 DEF_MIN_EXTENTS                        VARCHAR2(40)

 DEF_MAX_EXTENTS                        VARCHAR2(40)

 DEF_PCT_INCREASE                       VARCHAR2(40)

 DEF_FREELISTS                          NUMBER

 DEF_FREELIST_GROUPS                    NUMBER

 DEF_LOGGING                            VARCHAR2(7)

 DEF_COMPRESSION                        VARCHAR2(8)

 DEF_BUFFER_POOL                        VARCHAR2(7)

 

DBA_PENDING_CONV_TABLES: All tables which are not upgraded to the latest type version in the database

 

iSelfSchooling-SQL> desc DBA_PENDING_CONV_TABLES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

DBA_PENDING_TRANSACTIONS: information about unresolved global transactions

 

iSelfSchooling-SQL> desc DBA_PENDING_TRANSACTIONS;

 Name                          Null?    Type

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

 FORMATID                               NUMBER

 GLOBALID                               RAW(64)

 BRANCHID                               RAW(64)

 

DBA_PLSQL_OBJECT_SETTINGS: Compiler settings of all objects in the database

 

iSelfSchooling-SQL> desc DBA_PLSQL_OBJECT_SETTINGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 PLSQL_OPTIMIZE_LEVEL                   NUMBER

 PLSQL_CODE_TYPE                        VARCHAR2(4000)

 PLSQL_DEBUG                            VARCHAR2(4000)

 PLSQL_WARNINGS                         VARCHAR2(4000)

 NLS_LENGTH_SEMANTICS                   VARCHAR2(4000)

 PLSQL_CCFLAGS                          VARCHAR2(4000)

 

DBA_POLICIES: All row level security policies in the database

 

iSelfSchooling-SQL> desc DBA_POLICIES;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_GROUP                  NOT NULL VARCHAR2(30)

 POLICY_NAME                   NOT NULL VARCHAR2(30)

 PF_OWNER                      NOT NULL VARCHAR2(30)

 PACKAGE                                VARCHAR2(30)

 FUNCTION                      NOT NULL VARCHAR2(30)

 SEL                                    VARCHAR2(3)

 INS                                    VARCHAR2(3)

 UPD                                    VARCHAR2(3)

 DEL                                    VARCHAR2(3)

 IDX                                    VARCHAR2(3)

 CHK_OPTION                             VARCHAR2(3)

 ENABLE                                 VARCHAR2(3)

 STATIC_POLICY                          VARCHAR2(3)

 POLICY_TYPE                            VARCHAR2(24)

 LONG_PREDICATE                         VARCHAR2(3)

 

DBA_POLICY_CONTEXTS: All policy driving context defined for any synonym, table, or view in the database

 

iSelfSchooling-SQL> desc DBA_POLICY_CONTEXTS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 NAMESPACE                     NOT NULL VARCHAR2(30)

 ATTRIBUTE                     NOT NULL VARCHAR2(30)

 

DBA_POLICY_GROUPS: All policy groups defined for any synonym, table, view in the database

 

iSelfSchooling-SQL> desc DBA_POLICY_GROUPS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_GROUP                  NOT NULL VARCHAR2(30)

 

DBA_PRIV_AUDIT_OPTS: Describes current system privileges being audited across the system and by user

 

iSelfSchooling-SQL> desc DBA_PRIV_AUDIT_OPTS;

 Name                          Null?    Type

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

 USER_NAME                              VARCHAR2(30)

 PROXY_NAME                             VARCHAR2(30)

 PRIVILEGE                     NOT NULL VARCHAR2(40)

 SUCCESS                                VARCHAR2(10)

 FAILURE                                VARCHAR2(10)

 

DBA_PROCEDURES: Description of all procedures

 

iSelfSchooling-SQL> desc DBA_PROCEDURES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 PROCEDURE_NAME                         VARCHAR2(30)

 AGGREGATE                              VARCHAR2(3)

 PIPELINED                              VARCHAR2(3)

 IMPLTYPEOWNER                          VARCHAR2(30)

 IMPLTYPENAME                           VARCHAR2(30)

 PARALLEL                               VARCHAR2(3)

 INTERFACE                              VARCHAR2(3)

 DETERMINISTIC                          VARCHAR2(3)

 AUTHID                                 VARCHAR2(12)

 

DBA_PROFILES: Display all profiles and their limits

 

iSelfSchooling-SQL> desc DBA_PROFILES;

 Name                          Null?    Type

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

 PROFILE                       NOT NULL VARCHAR2(30)

 RESOURCE_NAME                 NOT NULL VARCHAR2(32)

 RESOURCE_TYPE                          VARCHAR2(8)

 LIMIT                                  VARCHAR2(40)

 

DBA_PROPAGATIONS: treams propagation in the database

 

iSelfSchooling-SQL> desc DBA_PROPAGATION;

 Name                          Null?    Type

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

 PROPAGATION_NAME              NOT NULL VARCHAR2(30)

 SOURCE_QUEUE_OWNER                     VARCHAR2(30)

 SOURCE_QUEUE_NAME                      VARCHAR2(30)

 DESTINATION_QUEUE_OWNER                VARCHAR2(30)

 DESTINATION_QUEUE_NAME                 VARCHAR2(30)

 DESTINATION_DBLINK                     VARCHAR2(128)

 RULE_SET_OWNER                         VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 QUEUE_TO_QUEUE                         VARCHAR2(5)

 STATUS                                 VARCHAR2(8)

 ERROR_MESSAGE                          VARCHAR2(4000)

 ERROR_DATE                             DATE

 

DBA_PROXIES: Information about all proxy connections

 

iSelfSchooling-SQL> desc DBA_PROXIES;

 Name                          Null?    Type

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

 PROXY                                  VARCHAR2(30)