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

ALL... | CLU... | IND... | MVI... | PRO... | REP... | SNA... | TAB...

 

ALL_MVIEW_AGGREGATES: Description of the materialized view aggregates accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_AGGREGATES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 POSITION_IN_SELECT            NOT NULL NUMBER

 CONTAINER_COLUMN              NOT NULL VARCHAR2(30)

 AGG_FUNCTION                           VARCHAR2(8)

 DISTINCTFLAG                           VARCHAR2(1)

 MEASURE                                LONG

 

ALL_MVIEW_ANALYSIS: Description of the materialized views accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_ANALYSIS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 MVIEW_TABLE_OWNER             NOT NULL VARCHAR2(30)

 CONTAINER_NAME                         VARCHAR2(30)

 LAST_REFRESH_SCN                       NUMBER

 LAST_REFRESH_DATE                      DATE

 REFRESH_METHOD                         VARCHAR2(8)

 SUMMARY                                VARCHAR2(1)

 FULLREFRESHTIM                         NUMBER

 INCREFRESHTIM                          NUMBER

 CONTAINS_VIEWS                         VARCHAR2(1)

 UNUSABLE                               VARCHAR2(1)

 RESTRICTED_SYNTAX                      VARCHAR2(1)

 INC_REFRESHABLE                        VARCHAR2(1)

 KNOWN_STALE                            VARCHAR2(1)

 INVALID                                VARCHAR2(1)

 REWRITE_ENABLED                        VARCHAR2(1)

 QUERY_LEN                              NUMBER

 QUERY                                  LONG

 REVISION                      NOT NULL NUMBER

 

ALL_MVIEW_COMMENTS: Comments on materialized views accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_COMMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 COMMENTS                               VARCHAR2(4000)

 

ALL_MVIEW_DETAIL_RELATIONS: Description of the materialized view detail tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_DETAIL_RELATIONS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 DETAILOBJ_OWNER               NOT NULL VARCHAR2(30)

 DETAILOBJ_NAME                NOT NULL VARCHAR2(30)

 DETAILOBJ_TYPE                         VARCHAR2(9)

 DETAILOBJ_ALIAS                        VARCHAR2(30)

 

ALL_MVIEW_JOINS: Description of a join between two columns in the WHERE clause of a materialized view accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_JOINS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 DETAILOBJ1_OWNER              NOT NULL VARCHAR2(30)

 DETAILOBJ1_RELATION           NOT NULL VARCHAR2(30)

 DETAILOBJ1_COLUMN             NOT NULL VARCHAR2(30)

 OPERATOR                               CHAR(1)

 OPERATOR_TYPE                          VARCHAR2(1)

 DETAILOBJ2_OWNER              NOT NULL VARCHAR2(30)

 DETAILOBJ2_RELATION           NOT NULL VARCHAR2(30)

 DETAILOBJ2_COLUMN             NOT NULL VARCHAR2(30)  

 

ALL_MVIEW_KEYS: Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user

 

iSelfSchooling-SQL> desc ALL_MVIEW_KEYS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 MVIEW_NAME                    NOT NULL VARCHAR2(30)

 POSITION_IN_SELECT            NOT NULL NUMBER

 CONTAINER_COLUMN              NOT NULL VARCHAR2(30)

 DETAILOBJ_OWNER               NOT NULL VARCHAR2(30)

 DETAILOBJ_NAME                NOT NULL VARCHAR2(30)

 DETAILOBJ_ALIAS                        VARCHAR2(30)

 DETAILOBJ_TYPE                         VARCHAR2(5)

 DETAILOBJ_COLUMN              NOT NULL VARCHAR2(30)  

 

ALL_MVIEW_LOGS: All materialized view logs in the database that the user can see

 

iSelfSchooling-SQL> desc ALL_MVIEW_LOGS;

 Name                          Null?    Type

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

 LOG_OWNER                              VARCHAR2(30)

 MASTER                                 VARCHAR2(30)

 LOG_TABLE                              VARCHAR2(30)

 LOG_TRIGGER                            VARCHAR2(30)

 ROWIDS                                 VARCHAR2(3)

 PRIMARY_KEY                            VARCHAR2(3)

 OBJECT_ID                              VARCHAR2(3)

 FILTER_COLUMNS                         VARCHAR2(3)

 SEQUENCE                               VARCHAR2(3)

 INCLUDE_NEW_VALUES                     VARCHAR2(3)

 

ALL_MVIEW_REFRESH_TIMES: Materialized views and their last refresh times for each master table that the user can look at

 

iSelfSchooling-SQL> desc ALL_MVIEW_REFRESH_TIMES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 MASTER_OWNER                           VARCHAR2(30)

 MASTER                                 VARCHAR2(30)

 LAST_REFRESH                           DATE

 

ALL_NESTED_TABLES: Description of nested tables in tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_NESTED_TABLES;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 TABLE_TYPE_OWNER                       VARCHAR2(30)

 TABLE_TYPE_NAME                        VARCHAR2(30)

 PARENT_TABLE_NAME                      VARCHAR2(30)

 PARENT_TABLE_COLUMN                    VARCHAR2(4000)

 STORAGE_SPEC                           VARCHAR2(30)

 RETURN_TYPE                            VARCHAR2(20)

 ELEMENT_SUBSTITUTABLE                  VARCHAR2(25)

 

ALL_NESTED_TABLE_COLS: Columns of nested tables

 

iSelfSchooling-SQL> desc ALL_NESTED_TABLE_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_OBJECTS: Objects accessible to the user

 

iSelfSchooling-SQL> desc ALL_OBJECTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 SUBOBJECT_NAME                         VARCHAR2(30)

 OBJECT_ID                     NOT NULL NUMBER

 DATA_OBJECT_ID                         NUMBER

 OBJECT_TYPE                            VARCHAR2(19)

 CREATED                       NOT NULL DATE

 LAST_DDL_TIME                 NOT NULL DATE

 TIMESTAMP                              VARCHAR2(19)

 STATUS                                 VARCHAR2(7)

 TEMPORARY                              VARCHAR2(1)

 GENERATED                              VARCHAR2(1)

 SECONDARY                              VARCHAR2(1)

 

ALL_OBJECT_TABLES: Description of all object tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_OBJECT_TABLES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 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)

 OBJECT_ID_TYPE                         VARCHAR2(16)

 TABLE_TYPE_OWNER                       VARCHAR2(30)

 TABLE_TYPE                             VARCHAR2(30)

 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)

 

ALL_OBJ_COLATTRS: Description of object columns and attributes contained in the tables accessible to the user

 

iSelfSchooling-SQL> desc ALL_OBJ_COLATTRS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 SUBSTITUTABLE                          VARCHAR2(15)

 

ALL_OLAP_ALTER_SESSION: Synonym for V$OLAP_ALTER_SESSION

 

iSelfSchooling-SQL> desc ALL_OLAP_ALTER_SESSION;

 Name                          Null?    Type

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

 ROLE                          NOT NULL VARCHAR2(30)

 CLAUSE_TEXT                            VARCHAR2(3000)

 

ALL_OPANCILLARY: All ancillary operators available to the user

 

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

 

ALL_OPARGUMENTS: All arguments of the operators available to the user

 

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

 

ALL_OPBINDINGS: All binding functions for operators available to the user

 

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

 

ALL_OPERATORS: All operators available to the user

 

iSelfSchooling-SQL> desc ALL_OPERATORS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 NUMBER_OF_BINDS               NOT NULL NUMBER

 

ALL_OPERATOR_COMMENTS: Comments for user-defined operators

 

iSelfSchooling-SQL> desc ALL_OPERATOR_COMMENTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OPERATOR_NAME                 NOT NULL VARCHAR2(30)

 COMMENTS                               VARCHAR2(4000)

 

ALL_OUTLINES: Synonym for USER_OUTLINES

 

iSelfSchooling-SQL> desc ALL_OUTLINES;

 Name                          Null?    Type

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

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

 

ALL_OUTLINE_HINTS: Synonym for USER_OUTLINE_HINTS

 

iSelfSchooling-SQL> desc ALL_OUTLINE_HINTS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 NODE                                   NUMBER

 STAGE                                  NUMBER

 JOIN_POS                               NUMBER

 HINT                                   CLOB

 

ALL_PARTIAL_DROP_TABS: All tables with patially dropped columns accessible to the user

 

iSelfSchooling-SQL> desc ALL_PARTIAL_DROP_TABS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

ALL_PART_COL_STATISTICS

 

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

 

ALL_PART_HISTOGRAMS

 

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

 

ALL_PART_INDEXES

 

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

 

ALL_PART_KEY_COLUMNS

 

iSelfSchooling-SQL> desc ALL_PART_KEY_COLUMNS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 NAME                                   VARCHAR2(30)

 OBJECT_TYPE                            CHAR(5)

 COLUMN_NAME                            VARCHAR2(4000)

 COLUMN_POSITION                        NUMBER

 

ALL_PART_LOBS

 

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

 

ALL_PART_TABLES

 

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

 

ALL_PENDING_CONV_TABLES: All tables accessible to the user which are not upgraded to the latest type version

 

iSelfSchooling-SQL> desc ALL_PENDING_CONV_TABLES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

ALL_PLSQL_OBJECT_SETTINGS: Compiler settings of stored objects accessible to the user

 

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

 

ALL_POLICIES: All policies for objects if the user has system privileges or owns the objects

 

iSelfSchooling-SQL> desc ALL_POLICIES;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 POLICY_GROUP                           VARCHAR2(30)

 POLICY_NAME                            VARCHAR2(30)

 PF_OWNER                               VARCHAR2(30)

 PACKAGE                                VARCHAR2(30)

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

 

ALL_POLICY_CONTEXTS: All policy driving context defined for all synonyms, tables, or views accessable to the user

 

iSelfSchooling-SQL> desc ALL_POLICY_CONTEXTS;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 NAMESPACE                              VARCHAR2(30)

 ATTRIBUTE                              VARCHAR2(30)

 

ALL_POLICY_GROUPS: All policy groups defined for any synonym, table or view accessable to the user

 

iSelfSchooling-SQL> desc ALL_POLICY_GROUPS;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 POLICY_GROUP                           VARCHAR2(30)

 

 

Google
 
Web web site