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_REPPROP: Propagation information about replicated objects

 

iSelfSchooling-SQL> desc ALL_REPPROP;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(16)

 DBLINK                        NOT NULL VARCHAR2(128)

 HOW                                    VARCHAR2(13)

 PROPAGATE_COMMENT                      VARCHAR2(80)

 

ALL_REPRESOLUTION: Description of all conflict resolutions for replicated tables which are accessible to the user

 

iSelfSchooling-SQL> desc ALL_REPRESOLUTION;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 SEQUENCE_NO                   NOT NULL NUMBER

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 FUNCTION_NAME                 NOT NULL VARCHAR2(92)

 PRIORITY_GROUP                         VARCHAR2(30)

 RESOLUTION_COMMENT                     VARCHAR2(80)

 

ALL_REPRESOLUTION_METHOD: All conflict resolution methods accessible to the user

 

iSelfSchooling-SQL> desc ALL_REPRESOLUTION_METHOD;

 Name                          Null?    Type

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

 CONFLICT_TYPE                          VARCHAR2(10)

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 

ALL_REPRESOLUTION_STATISTICS: Statistics for conflict resolutions for replicated tables which are accessible to the user

 

iSelfSchooling-SQL> desc ALL_REPRESOLUTION_STATISTICS;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 FUNCTION_NAME                          VARCHAR2(92)

 PRIORITY_GROUP                         VARCHAR2(30)

 RESOLVED_DATE                 NOT NULL DATE

 PRIMARY_KEY_VALUE             NOT NULL VARCHAR2(2000)

 

ALL_REPRESOL_STATS_CONTROL: Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user

 

iSelfSchooling-SQL> desc ALL_REPRESOL_STATS_CONTROL;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CREATED                       NOT NULL DATE

 STATUS                                 VARCHAR2(9)

 STATUS_UPDATE_DATE            NOT NULL DATE

 PURGED_DATE                            DATE

 LAST_PURGE_START_DATE                  DATE

 LAST_PURGE_END_DATE                    DATE

 

ALL_REPSCHEMA: N-way replication information

 

iSelfSchooling-SQL> desc ALL_REPSCHEMA;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 DBLINK                        NOT NULL VARCHAR2(128)

 MASTERDEF                              VARCHAR2(1)

 SNAPMASTER                             VARCHAR2(1)

 MASTER_COMMENT                         VARCHAR2(80)

 GNAME                         NOT NULL VARCHAR2(30)

 MASTER                                 VARCHAR2(1)

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 

ALL_REPSITES: N-way replication information

 

iSelfSchooling-SQL> desc ALL_REPSITES;

 Name                          Null?    Type

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

 GNAME                         NOT NULL VARCHAR2(30)

 DBLINK                        NOT NULL VARCHAR2(128)

 MASTERDEF                              VARCHAR2(1)

 SNAPMASTER                             VARCHAR2(1)

 MASTER_COMMENT                         VARCHAR2(80)

 MASTER                                 VARCHAR2(1)

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 

ALL_REWRITE_EQUIVALENCES: Description of all rewrite equivalence accessible to the user

 

iSelfSchooling-SQL> desc ALL_REWRITE_EQUIVALENCES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 SOURCE_STMT                            CLOB

 DESTINATION_STMT                       CLOB

 REWRITE_MODE                           VARCHAR2(10)

 

ALL_RULES: Rules seen by the user

 

iSelfSchooling-SQL> desc ALL_RULES;

 Name                          Null?    Type

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

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_CONDITION                         CLOB

 RULE_EVALUATION_CONTEXT_OWNER          VARCHAR2(30)

 RULE_EVALUATION_CONTEXT_NAME           VARCHAR2(30)

 RULE_ACTION_CONTEXT                    RE$NV_LIST

 RULE_COMMENT                           VARCHAR2(4000)

 

ALL_RULESETS: Rule sets seen by the user: maintained for backward compatibility

 

iSelfSchooling-SQL> desc ALL_RULESETS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 RULESET_NAME                  NOT NULL VARCHAR2(30)

 RULESET_STORAGE_TABLE                  VARCHAR2

 BASE_TABLE                             VARCHAR2(61)

 RULESET_COMMENT                        VARCHAR2(4000)

 

ALL_RULE_SETS: Rule sets seen by the user

 

iSelfSchooling-SQL> desc ALL_RULE_SETS;

 Name                          Null?    Type

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

 RULE_SET_OWNER                NOT NULL VARCHAR2(30)

 RULE_SET_NAME                 NOT NULL VARCHAR2(30)

 RULE_SET_EVAL_CONTEXT_OWNER            VARCHAR2(30)

 RULE_SET_EVAL_CONTEXT_NAME             VARCHAR2(30)

 RULE_SET_COMMENT                       VARCHAR2(4000)

 

ALL_RULE_SET_RULES: Rules in all rule sets seen by the user

 

iSelfSchooling-SQL> desc ALL_RULE_SET_RULES;

 Name                          Null?    Type

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

 RULE_SET_OWNER                NOT NULL VARCHAR2(30)

 RULE_SET_NAME                 NOT NULL VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 RULE_SET_RULE_ENABLED                  VARCHAR2(8)

 RULE_SET_RULE_EVAL_CTX_OWNER           VARCHAR2(30)

 RULE_SET_RULE_EVAL_CTX_NAME            VARCHAR2(30)

 RULE_SET_RULE_COMMENT                  VARCHAR2(4000)

 

ALL_SCHEDULER_CHAINS: All scheduler chains in the database visible to current user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAINS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 NUMBER_OF_RULES                        NUMBER

 NUMBER_OF_STEPS                        NUMBER

 ENABLED                                VARCHAR2(5)

 EVALUATION_INTERVAL                    INTERVAL DAY(3) TO

                                        SECOND(0)

 USER_RULE_SET                          VARCHAR2(5)

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_CHAIN_RULES: All rules from scheduler chains visible to the current user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_RULES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                              VARCHAR2(30)

 CONDITION                              VARCHAR2(4000)

 ACTION                                 VARCHAR2(4000)

 COMMENTS                               VARCHAR2(4000)

 

ALL_SCHEDULER_CHAIN_STEPS: All steps of scheduler chains visible to the current user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_STEPS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 CHAIN_NAME                    NOT NULL VARCHAR2(30)

 STEP_NAME                     NOT NULL VARCHAR2(30)

 PROGRAM_OWNER                          VARCHAR2(98)

 PROGRAM_NAME                           VARCHAR2(98)

 EVENT_SCHEDULE_OWNER                   VARCHAR2(98)

 EVENT_SCHEDULE_NAME                    VARCHAR2(98)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 SKIP                                   VARCHAR2(5)

 PAUSE                                  VARCHAR2(5)

 RESTART_ON_RECOVERY                    VARCHAR2(5)

 STEP_TYPE                              VARCHAR2(14)

 TIMEOUT                                INTERVAL DAY(3)TO SECOND(0)

 

ALL_SCHEDULER_GLOBAL_ATTRIBUTE: All scheduler global attributes

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_GLOBAL_ATTRIBUTE;

 Name                          Null?    Type

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

 ATTRIBUTE_NAME                NOT NULL VARCHAR2(30)

 VALUE                                  VARCHAR2(128)

 

ALL_SCHEDULER_JOBS: All scheduler jobs visible to the user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_JOBS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 JOB_NAME                      NOT NULL VARCHAR2(30)

 JOB_SUBNAME                            VARCHAR2(30)

 JOB_CREATOR                            VARCHAR2(30)

 CLIENT_ID                              VARCHAR2(64)

 GLOBAL_UID                             VARCHAR2(32)

 PROGRAM_OWNER                          VARCHAR2(4000)

 PROGRAM_NAME                           VARCHAR2(4000)

 JOB_TYPE                               VARCHAR2(16)

 JOB_ACTION                             VARCHAR2(4000)

 NUMBER_OF_ARGUMENTS                    NUMBER

 SCHEDULE_OWNER                         VARCHAR2(4000)

 SCHEDULE_NAME                          VARCHAR2(4000)

 SCHEDULE_TYPE                          VARCHAR2(12)

 START_DATE                             TIMESTAMP(6) WITH TIME ZONE

 REPEAT_INTERVAL                        VARCHAR2(4000)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 EVENT_RULE                             VARCHAR2(65)

 END_DATE                               TIMESTAMP(6) WITH TIME ZONE

 JOB_CLASS                              VARCHAR2(30)

 ENABLED                                VARCHAR2(5)

 AUTO_DROP                              VARCHAR2(5)

 RESTARTABLE                            VARCHAR2(5)

 STATE                                  VARCHAR2(15)

 JOB_PRIORITY                           NUMBER

 RUN_COUNT                              NUMBER

 MAX_RUNS                               NUMBER

 FAILURE_COUNT                          NUMBER

 MAX_FAILURES                           NUMBER

 RETRY_COUNT                            NUMBER

 LAST_START_DATE                        TIMESTAMP(6) WITH TIME ZONE

 LAST_RUN_DURATION                      INTERVAL DAY(9) TO SECOND(0)

 NEXT_RUN_DATE                          TIMESTAMP(6) WITH TIME ZONE

 SCHEDULE_LIMIT                         INTERVAL DAY(3) TO SECOND(0)

 MAX_RUN_DURATION                       INTERVAL DAY(3) TO SECOND(0)

 LOGGING_LEVEL                          VARCHAR2(4)

 STOP_ON_WINDOW_CLOSE                   VARCHAR2(5)

 INSTANCE_STICKINESS                    VARCHAR2(5)

 RAISE_EVENTS                           VARCHAR2(4000)

 SYSTEM                                 VARCHAR2(5)

 JOB_WEIGHT                             NUMBER

 NLS_ENV                                VARCHAR2(4000)

 SOURCE                                 VARCHAR2(128)

 DESTINATION                            VARCHAR2(128)

 COMMENTS                               VARCHAR2(240)

 FLAGS                                  NUMBER

 

ALL_SCHEDULER_JOB_ARGS: All arguments with set values of all scheduler jobs in the database

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_ARGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 JOB_NAME                      NOT NULL VARCHAR2(30)

 ARGUMENT_NAME                          VARCHAR2(30)

 ARGUMENT_POSITION                      NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 VALUE                                  VARCHAR2(4000)

 ANYDATA_VALUE                          ANYDATA

 OUT_ARGUMENT                           VARCHAR2(5)

 

ALL_SCHEDULER_JOB_CLASSES: All scheduler classes visible to the user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_CLASSES;

 Name                          Null?    Type

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

 JOB_CLASS_NAME                NOT NULL VARCHAR2(30)

 RESOURCE_CONSUMER_GROUP                VARCHAR2(30)

 SERVICE                                VARCHAR2(64)

 LOGGING_LEVEL                          VARCHAR2(4)

 LOG_HISTORY                            NUMBER

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_JOB_LOG: Logged information for all scheduler jobs

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_LOG;

 Name                          Null?    Type

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

 LOG_ID                        NOT NULL NUMBER

 LOG_DATE                               TIMESTAMP(6)

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(65)

 JOB_SUBNAME                            VARCHAR2(65)

 JOB_CLASS                              VARCHAR2(30)

 OPERATION                              VARCHAR2(30)

 STATUS                                 VARCHAR2(30)

 USER_NAME                              VARCHAR2(30)

 CLIENT_ID                              VARCHAR2(64)

 GLOBAL_UID                             VARCHAR2(32)

 ADDITIONAL_INFO                        CLOB

 

ALL_SCHEDULER_JOB_RUN_DETAILS: The details of a job run

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_JOB_RUN_DETAILS;

 Name                          Null?    Type

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

 LOG_ID                                 NUMBER

 LOG_DATE                               TIMESTAMP(6)

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(65)

 JOB_SUBNAME                            VARCHAR2(65)

 STATUS                                 VARCHAR2(30)

 ERROR#                                 NUMBER

 REQ_START_DATE                         TIMESTAMP(6)

 ACTUAL_START_DATE                      TIMESTAMP(6)

 RUN_DURATION                           INTERVAL DAY(3)

 INSTANCE_ID                            NUMBER

 SESSION_ID                             VARCHAR2(30)

 SLAVE_PID                              VARCHAR2(30)

 CPU_USED                               INTERVAL DAY(3)

 ADDITIONAL_INFO                        VARCHAR2(4000)

 

ALL_SCHEDULER_PROGRAMS: All scheduler programs visible to the user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_PROGRAMS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 PROGRAM_NAME                  NOT NULL VARCHAR2(30)

 PROGRAM_TYPE                           VARCHAR2(16)

 PROGRAM_ACTION                         VARCHAR2(4000)

 NUMBER_OF_ARGUMENTS                    NUMBER

 ENABLED                                VARCHAR2(5)

 DETACHED                               VARCHAR2(5)

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_PROGRAM_ARGS: All arguments of all scheduler programs visible to the user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_PROGRAM_ARGS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 PROGRAM_NAME                  NOT NULL VARCHAR2(30)

 ARGUMENT_NAME                          VARCHAR2(30)

 ARGUMENT_POSITION             NOT NULL NUMBER

 ARGUMENT_TYPE                          VARCHAR2(61)

 METADATA_ATTRIBUTE                     VARCHAR2(12)

 DEFAULT_VALUE                          VARCHAR2(4000)

 DEFAULT_ANYDATA_VALUE                  ANYDATA

 OUT_ARGUMENT                           VARCHAR2(5)

 

ALL_SCHEDULER_RUNNING_CHAINS: All job steps of running job chains visible to the user

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_RUNNING_CHAINS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 JOB_NAME                               VARCHAR2(30)

 JOB_SUBNAME                            VARCHAR2(30)

 CHAIN_OWNER                            VARCHAR2(30)

 CHAIN_NAME                             VARCHAR2(30)

 STEP_NAME                              VARCHAR2(30)

 STATE                                  VARCHAR2(11)

 ERROR_CODE                             NUMBER

 COMPLETED                              VARCHAR2(5)

 START_DATE                             TIMESTAMP(6)

 END_DATE                               TIMESTAMP(6)

 DURATION                               INTERVAL DAY(9)

 SKIP                                   VARCHAR2(5)

 PAUSE                                  VARCHAR2(5)

 RESTART_ON_RECOVERY                    VARCHAR2(5)

 STEP_JOB_SUBNAME                       VARCHAR2(30)

 STEP_JOB_LOG_ID                        NUMBER

 

ALL_SCHEDULER_SCHEDULES: All schedules in the database

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_SCHEDULES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 SCHEDULE_NAME                 NOT NULL VARCHAR2(30)

 SCHEDULE_TYPE                          VARCHAR2(8)

 START_DATE                             TIMESTAMP(6) WITH TIME ZONE

 REPEAT_INTERVAL                        VARCHAR2(4000)

 EVENT_QUEUE_OWNER                      VARCHAR2(30)

 EVENT_QUEUE_NAME                       VARCHAR2(30)

 EVENT_QUEUE_AGENT                      VARCHAR2(30)

 EVENT_CONDITION                        VARCHAR2(4000)

 END_DATE                               TIMESTAMP(6) WITH TIME ZONE

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_WINDOWS: All scheduler windows in the database

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOWS;

 Name                          Null?    Type

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

 WINDOW_NAME                   NOT NULL VARCHAR2(30)

 RESOURCE_PLAN                          VARCHAR2(30)

 SCHEDULE_OWNER                         VARCHAR2(4000)

 SCHEDULE_NAME                          VARCHAR2(4000)

 SCHEDULE_TYPE                          VARCHAR2(8)

 START_DATE                             TIMESTAMP(6)

 REPEAT_INTERVAL                        VARCHAR2(4000)

 END_DATE                               TIMESTAMP(6)

 DURATION                               INTERVAL DAY(3)

 WINDOW_PRIORITY                        VARCHAR2(4)

 NEXT_START_DATE                        TIMESTAMP(6)

 LAST_START_DATE                        TIMESTAMP(6)

 ENABLED                                VARCHAR2(5)

 ACTIVE                                 VARCHAR2(5)

 MANUAL_OPEN_TIME                       TIMESTAMP(6)

 MANUAL_DURATION                        INTERVAL DAY(3)

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_WINDOW_DETAILS: The details of a window

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_DETAILS;

 Name                          Null?    Type

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

 LOG_ID                                 NUMBER

 LOG_DATE                               TIMESTAMP(6)

 WINDOW_NAME                            VARCHAR2(65)

 REQ_START_DATE                         TIMESTAMP(6)

 ACTUAL_START_DATE                      TIMESTAMP(6)

 WINDOW_DURATION                        INTERVAL DAY(3)

 ACTUAL_DURATION                        INTERVAL DAY(3)

 INSTANCE_ID                            NUMBER

 ADDITIONAL_INFO                        VARCHAR2(4000)

 

ALL_SCHEDULER_WINDOW_GROUPS: All scheduler window groups in the database

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_GROUPS;

 Name                          Null?    Type

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

 WINDOW_GROUP_NAME             NOT NULL VARCHAR2(30)

 ENABLED                                VARCHAR2(5)

 NUMBER_OF_WINDOWS                      NUMBER

 NEXT_START_DATE                        VARCHAR2(64)

 COMMENTS                               VARCHAR2(240)

 

ALL_SCHEDULER_WINDOW_LOG: Logged information for all scheduler windows

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_WINDOW_LOG;

 Name                          Null?    Type

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

 LOG_ID                        NOT NULL NUMBER

 LOG_DATE                               TIMESTAMP(6)

 WINDOW_NAME                            VARCHAR2(65)

 OPERATION                              VARCHAR2(30)

 STATUS                                 VARCHAR2(30)

 USER_NAME                              VARCHAR2(30)

 CLIENT_ID                              VARCHAR2(64)

 GLOBAL_UID                             VARCHAR2(32)

 ADDITIONAL_INFO                        CLOB

 

ALL_SCHEDULER_WINGROUP_MEMBERS: Members of all scheduler window groups in the database

 

iSelfSchooling-SQL> desc ALL_SCHEDULER_WINGROUP_MEMBERS;

 Name                          Null?    Type

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

 WINDOW_GROUP_NAME             NOT NULL VARCHAR2(30)

 WINDOW_NAME                   NOT NULL VARCHAR2(30)

 

ALL_SECONDARY_OBJECTS: All secondary objects for domain indexes

 

iSelfSchooling-SQL> desc ALL_SECONDARY_OBJECTS;

 Name                          Null?    Type

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

 INDEX_OWNER                   NOT NULL VARCHAR2(30)

 INDEX_NAME                    NOT NULL VARCHAR2(30)

 SECONDARY_OBJECT_OWNER        NOT NULL VARCHAR2(30)

 SECONDARY_OBJECT_NAME         NOT NULL VARCHAR2(30)

 

ALL_SEC_RELEVANT_COLS: Security Relevant columns of all VPD policies for tables or views which the user has access

 

iSelfSchooling-SQL> desc ALL_SEC_RELEVANT_COLS;

 Name                          Null?    Type

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

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 POLICY_GROUP                           VARCHAR2(30)

 POLICY_NAME                            VARCHAR2(30)

 SEC_REL_COLUMN                         VARCHAR2(30)

 COLUMN_OPTION                          VARCHAR2(8)

 

ALL_SEQUENCES: Description of SEQUENCEs accessible to the user

 

iSelfSchooling-SQL> desc ALL_SEQUENCES;

 Name                          Null?    Type

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

 SEQUENCE_OWNER                NOT NULL VARCHAR2(30)

 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

 

ALL_SERVICES

 

iSelfSchooling-SQL> desc ALL_SERVICES;

 Name                          Null?    Type

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

 SERVICE_ID                             NUMBER

 NAME                                   VARCHAR2(64)

 NAME_HASH                              NUMBER

 NETWORK_NAME                           VARCHAR2(512)

 CREATION_DATE                          DATE

 CREATION_DATE_HASH                     NUMBER

 FAILOVER_METHOD                        VARCHAR2(64)

 FAILOVER_TYPE                          VARCHAR2(64)

 FAILOVER_RETRIES                       NUMBER(10)

 FAILOVER_DELAY                         NUMBER(10)

 MIN_CARDINALITY                        NUMBER

 MAX_CARDINALITY                        NUMBER

 GOAL                                   VARCHAR2(12)

 DTP                                    VARCHAR2(1)

 ENABLED                                VARCHAR2(3)

 AQ_HA_NOTIFICATIONS                    VARCHAR2(3)

 CLB_GOAL                               VARCHAR2(5)

 

ALL_SNAPSHOTS: Snapshots the user can access

 

iSelfSchooling-SQL> desc ALL_SNAPSHOTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 MASTER_VIEW                            VARCHAR2(30)

 MASTER_OWNER                           VARCHAR2(30)

 MASTER                                 VARCHAR2(30)

 MASTER_LINK                            VARCHAR2(128)

 CAN_USE_LOG                            VARCHAR2(3)

 UPDATABLE                              VARCHAR2(3)

 REFRESH_METHOD                         VARCHAR2(11)

 LAST_REFRESH                           DATE

 ERROR                                  NUMBER

 FR_OPERATIONS                          VARCHAR2(10)

 CR_OPERATIONS                          VARCHAR2(10)

 TYPE                                   VARCHAR2(8)

 NEXT                                   VARCHAR2(200)

 START_WITH                             DATE

 REFRESH_GROUP                          NUMBER

 UPDATE_TRIG                            VARCHAR2(30)

 UPDATE_LOG                             VARCHAR2(30)

 QUERY                                  LONG

 MASTER_ROLLBACK_SEG                    VARCHAR2(30)

 STATUS                                 VARCHAR2(7)

 REFRESH_MODE                           VARCHAR2(8)

 PREBUILT                               VARCHAR2(3)

 

 

Google
 
Web web site