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

ADV... | AUD... | FIL... | LOB... | PAR... | REP... | SEQ... | TAB...

 

USER_ADVISOR_ACTIONS

 

iSelfSchooling-SQL> desc USER_ADVISOR_ACTIONS;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 REC_ID                        NOT NULL NUMBER

 ACTION_ID                     NOT NULL NUMBER

 OBJECT_ID                              NUMBER

 COMMAND                                VARCHAR2(64)

 COMMAND_ID                    NOT NULL NUMBER

 FLAGS                                  NUMBER

 ATTR1                                  VARCHAR2(4000)

 ATTR2                                  VARCHAR2(4000)

 ATTR3                                  VARCHAR2(4000)

 ATTR4                                  VARCHAR2(4000)

 ATTR5                                  CLOB

 ATTR6                                  CLOB

 NUM_ATTR1                              NUMBER

 NUM_ATTR2                              NUMBER

 NUM_ATTR3                              NUMBER

 NUM_ATTR4                              NUMBER

 NUM_ATTR5                              NUMBER

 MESSAGE                                VARCHAR2(4000)

 

USER_ADVISOR_DIRECTIVES

 

iSelfSchooling-SQL> desc USER_ADVISOR_DIRECTIVES;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 SOURCE_TASK_ID                         NUMBER

 DIRECTIVE_ID                  NOT NULL NUMBER

 REC_OBJ_OWNER                          VARCHAR2(30)

 REC_OBJ_NAME                           VARCHAR2(30)

 REC_ID                                 NUMBER

 REC_ACTION_ID                          NUMBER

 COMMAND                                VARCHAR2(64)

 ATTR1                                  VARCHAR2(2000)

 ATTR2                                  VARCHAR2(2000)

 ATTR3                                  VARCHAR2(2000)

 ATTR4                                  VARCHAR2(2000)

 ATTR5                                  CLOB

 

USER_ADVISOR_FINDINGS

 

iSelfSchooling-SQL> desc USER_ADVISOR_FINDINGS;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 FINDING_ID                    NOT NULL NUMBER

 TYPE                                   VARCHAR2(11)

 PARENT                        NOT NULL NUMBER

 OBJECT_ID                              NUMBER

 IMPACT_TYPE                            VARCHAR2(4000)

 IMPACT                                 NUMBER

 MESSAGE                                VARCHAR2(4000)

 MORE_INFO                              VARCHAR2(4000)

 

USER_ADVISOR_JOURNAL

 

iSelfSchooling-SQL> desc USER_ADVISOR_JOURNAL;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 JOURNAL_ENTRY_SEQ             NOT NULL NUMBER

 JOURNAL_ENTRY_TYPE                     VARCHAR2(12)

 JOURNAL_ENTRY                          VARCHAR2(4000)

 

USER_ADVISOR_LOG

 

iSelfSchooling-SQL> desc USER_ADVISOR_LOG;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 EXECUTION_START                        DATE

 EXECUTION_END                          DATE

 STATUS                                 VARCHAR2(11)

 STATUS_MESSAGE                         VARCHAR2(4000)

 PCT_COMPLETION_TIME                    NUMBER

 PROGRESS_METRIC                        NUMBER

 METRIC_UNITS                           VARCHAR2(64)

 ACTIVITY_COUNTER                       NUMBER

 RECOMMENDATION_COUNT                   NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 

USER_ADVISOR_OBJECTS

 

iSelfSchooling-SQL> desc USER_ADVISOR_OBJECTS;

 Name                          Null?    Type

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

 OBJECT_ID                     NOT NULL NUMBER

 TYPE                                   VARCHAR2(64)

 TYPE_ID                       NOT NULL NUMBER

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 ATTR1                                  VARCHAR2(4000)

 ATTR2                                  VARCHAR2(4000)

 ATTR3                                  VARCHAR2(4000)

 ATTR4                                  CLOB

 ATTR5                                  VARCHAR2(4000)

 

USER_ADVISOR_PARAMETERS

 

iSelfSchooling-SQL> desc USER_ADVISOR_PARAMETERS;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 PARAMETER_NAME                NOT NULL VARCHAR2(30)

 PARAMETER_VALUE               NOT NULL VARCHAR2(4000)

 PARAMETER_TYPE                         VARCHAR2(10)

 IS_DEFAULT                             VARCHAR2(1)

 IS_OUTPUT                              VARCHAR2(1)

 IS_MODIFIABLE_ANYTIME                  VARCHAR2(1)

 DESCRIPTION                            VARCHAR2(4000)

 

USER_ADVISOR_RATIONALE

 

iSelfSchooling-SQL> desc USER_ADVISOR_RATIONALE;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 REC_ID                                 NUMBER

 RATIONALE_ID                  NOT NULL NUMBER

 IMPACT_TYPE                            VARCHAR2(4000)

 IMPACT                                 NUMBER

 MESSAGE                                VARCHAR2(4000)

 OBJECT_ID                              NUMBER

 TYPE                                   VARCHAR2(30)

 ATTR1                                  VARCHAR2(4000)

 ATTR2                                  VARCHAR2(4000)

 ATTR3                                  VARCHAR2(4000)

 ATTR4                                  VARCHAR2(4000)

 ATTR5                                  CLOB

 

USER_ADVISOR_RECOMMENDATIONS

 

iSelfSchooling-SQL> desc USER_ADVISOR_RECOMMENDATIONS;

 Name                          Null?    Type

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

 REC_ID                        NOT NULL NUMBER

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 FINDING_ID                             NUMBER

 TYPE                                   VARCHAR2(30)

 RANK                                   NUMBER

 PARENT_REC_IDS                         VARCHAR2(4000)

 BENEFIT_TYPE                           VARCHAR2(4000)

 BENEFIT                                NUMBER

 ANNOTATION_STATUS                      VARCHAR2(11)

 FLAGS                                  NUMBER

 

USER_ADVISOR_SQLA_REC_SUM

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_REC_SUM;

 Name                          Null?    Type

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

 TASK_ID                                NUMBER

 TASK_NAME                              VARCHAR2(30)

 REC_ID                                 NUMBER

 TOTAL_STMTS                            NUMBER

 TOTAL_PRECOST                          NUMBER

 TOTAL_POSTCOST                         NUMBER

 

USER_ADVISOR_SQLA_WK_MAP

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_MAP;

 Name                          Null?    Type

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

 TASK_ID                                NUMBER

 TASK_NAME                              VARCHAR2(30)

 WORKLOAD_ID                            NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 

USER_ADVISOR_SQLA_WK_STMTS

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_STMTS;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 SQL_ID                        NOT NULL NUMBER

 HASH_VALUE                             NUMBER

 USERNAME                               VARCHAR2(30)

 MODULE                                 VARCHAR2(64)

 ACTION                                 VARCHAR2(64)

 CPU_TIME                               NUMBER

 BUFFER_GETS                            NUMBER

 DISK_READS                             NUMBER

 ELAPSED_TIME                           NUMBER

 ROWS_PROCESSED                         NUMBER

 EXECUTIONS                             NUMBER

 PRECOST                                NUMBER

 POSTCOST                               NUMBER

 LAST_EXECUTION_DATE                    DATE

 PRIORITY                               NUMBER

 COMMAND_TYPE                           NUMBER

 STAT_PERIOD                            NUMBER

 SQL_TEXT                               CLOB

 IMPORTANCE                             NUMBER

 REC_ID                                 NUMBER

 VALIDATED                              NUMBER

 

USER_ADVISOR_SQLW_COLVOL

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_COLVOL;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 UPDATE_FREQ                            NUMBER

 UPDATED_ROWS                           NUMBER

 

USER_ADVISOR_SQLW_JOURNAL

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_JOURNAL;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 JOURNAL_ENTRY_SEQ             NOT NULL NUMBER

 JOURNAL_ENTRY_TYPE                     VARCHAR2(12)

 JOURNAL_ENTRY                          VARCHAR2(4000)

 

USER_ADVISOR_SQLW_PARAMETERS

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_PARAMETERS;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 PARAMETER_NAME                NOT NULL VARCHAR2(30)

 PARAMETER_VALUE               NOT NULL VARCHAR2(4000)

 PARAMETER_TYPE                         VARCHAR2(10)

 DESCRIPTION                            VARCHAR2(4000)

 

USER_ADVISOR_SQLW_STMTS

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_STMTS;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 SQL_ID                        NOT NULL NUMBER

 HASH_VALUE                             NUMBER

 USERNAME                               VARCHAR2(30)

 MODULE                                 VARCHAR2(64)

 ACTION                                 VARCHAR2(64)

 CPU_TIME                               NUMBER

 BUFFER_GETS                            NUMBER

 DISK_READS                             NUMBER

 ELAPSED_TIME                           NUMBER

 ROWS_PROCESSED                         NUMBER

 EXECUTIONS                             NUMBER

 OPTIMIZER_COST                         NUMBER

 LAST_EXECUTION_DATE                    DATE

 PRIORITY                               NUMBER

 COMMAND_TYPE                           NUMBER

 STAT_PERIOD                            NUMBER

 SQL_TEXT                               CLOB

 VALID                                  NUMBER

 

USER_ADVISOR_SQLW_SUM

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_SUM;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 CREATE_DATE                   NOT NULL DATE

 MODIFY_DATE                   NOT NULL DATE

 NUM_SELECT_STMT                        NUMBER

 NUM_UPDATE_STMT                        NUMBER

 NUM_DELETE_STMT                        NUMBER

 NUM_INSERT_STMT                        NUMBER

 NUM_MERGE_STMT                         NUMBER

 SOURCE                                 VARCHAR2(30)

 HOW_CREATED                            VARCHAR2(30)

 DATA_SOURCE                            VARCHAR2(2000)

 READ_ONLY                              VARCHAR2(5)


 

USER_ADVISOR_SQLW_TABLES

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TABLES;

 Name                          Null?    Type

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

 WORKLOAD_ID                            NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 SQL_ID                                 NUMBER

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 

USER_ADVISOR_SQLW_TABVOL

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TABVOL;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 TABLE_OWNER                            VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 UPDATE_FREQ                            NUMBER

 INSERT_FREQ                            NUMBER

 DELETE_FREQ                            NUMBER

 DIRECT_LOAD_FREQ                       NUMBER

 UPDATED_ROWS                           NUMBER

 INSERTED_ROWS                          NUMBER

 DELETED_ROWS                           NUMBER

 DIRECT_LOAD_ROWS                       NUMBER

 

USER_ADVISOR_SQLW_TEMPLATES

 

iSelfSchooling-SQL> desc USER_ADVISOR_SQLW_TEMPLATES;

 Name                          Null?    Type

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

 WORKLOAD_ID                   NOT NULL NUMBER

 WORKLOAD_NAME                          VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 CREATE_DATE                   NOT NULL DATE

 MODIFY_DATE                   NOT NULL DATE

 SOURCE                                 VARCHAR2(30)

 READ_ONLY                              VARCHAR2(5)

 

USER_ADVISOR_TASKS

 

iSelfSchooling-SQL> desc USER_ADVISOR_TASKS;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 ADVISOR_NAME                           VARCHAR2(30)

 CREATED                       NOT NULL DATE

 LAST_MODIFIED                 NOT NULL DATE

 PARENT_TASK_ID                         NUMBER

 PARENT_REC_ID                          NUMBER

 EXECUTION_START                        DATE

 EXECUTION_END                          DATE

 STATUS                                 VARCHAR2(11)

 STATUS_MESSAGE                         VARCHAR2(4000)

 PCT_COMPLETION_TIME                    NUMBER

 PROGRESS_METRIC                        NUMBER

 METRIC_UNITS                           VARCHAR2(64)

 ACTIVITY_COUNTER                       NUMBER

 RECOMMENDATION_COUNT                   NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 SOURCE                                 VARCHAR2(30)

 HOW_CREATED                            VARCHAR2(30)

 READ_ONLY                              VARCHAR2(5)

 ADVISOR_ID                    NOT NULL NUMBER

 

USER_ADVISOR_TEMPLATES

 

iSelfSchooling-SQL> desc USER_ADVISOR_TEMPLATES;

 Name                          Null?    Type

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

 TASK_ID                       NOT NULL NUMBER

 TASK_NAME                              VARCHAR2(30)

 DESCRIPTION                            VARCHAR2(256)

 ADVISOR_NAME                           VARCHAR2(30)

 CREATED                       NOT NULL DATE

 LAST_MODIFIED                 NOT NULL DATE

 SOURCE                                 VARCHAR2(30)

 READ_ONLY                              VARCHAR2(5)

 

USER_ALL_TABLES: Description of all object and relational tables owned by the user's

 

iSelfSchooling-SQL> desc USER_ALL_TABLES;

 Name                          Null?    Type

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

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

 

USER_AQ_AGENT_PRIVS:

 

iSelfSchooling-SQL> desc USER_AQ_AGENT_PRIVS;

 Name                          Null?    Type

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

 AGENT_NAME                    NOT NULL VARCHAR2(30)

 HTTP_ENABLED                           VARCHAR2(4)

 SMTP_ENABLED                           VARCHAR2(4)

 

USER_ARGUMENTS: Arguments in object accessible to the user

 

iSelfSchooling-SQL> desc USER_ARGUMENTS;

 Name                          Null?    Type

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

 OBJECT_NAME                            VARCHAR2(30)

 PACKAGE_NAME                           VARCHAR2(30)

 OBJECT_ID                     NOT NULL NUMBER

 OVERLOAD                               VARCHAR2(40)

 ARGUMENT_NAME                          VARCHAR2(30)

 POSITION                      NOT NULL NUMBER

 SEQUENCE                      NOT NULL NUMBER

 DATA_LEVEL                    NOT NULL NUMBER

 DATA_TYPE                              VARCHAR2(30)

 DEFAULT_VALUE                          LONG

 DEFAULT_LENGTH                         NUMBER

 IN_OUT                                 VARCHAR2(9)

 DATA_LENGTH                            NUMBER

 DATA_PRECISION                         NUMBER

 DATA_SCALE                             NUMBER

 RADIX                                  NUMBER

 CHARACTER_SET_NAME                     VARCHAR2(44)

 TYPE_OWNER                             VARCHAR2(30)

 TYPE_NAME                              VARCHAR2(30)

 TYPE_SUBNAME                           VARCHAR2(30)

 TYPE_LINK                              VARCHAR2(128)

 PLS_TYPE                               VARCHAR2(30)

 CHAR_LENGTH                            NUMBER

 CHAR_USED                              VARCHAR2(1)

 

USER_ASSOCIATIONS: All assocations defined by the user

 

iSelfSchooling-SQL> desc USER_ASSOCIATIONS;

 Name                          Null?    Type

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

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(9)

 STATSTYPE_SCHEMA                       VARCHAR2(30)

 STATSTYPE_NAME                         VARCHAR2(30)

 DEF_SELECTIVITY                        NUMBER

 DEF_CPU_COST                           NUMBER

 DEF_IO_COST                            NUMBER

 DEF_NET_COST                           NUMBER

 INTERFACE_VERSION                      NUMBER

 

USER_ATTRIBUTE_TRANSFORMATIONS

 

iSelfSchooling-SQL> desc USER_ATTRIBUTE_TRANSFORMATIONS;

 Name                          Null?    Type

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

 TRANSFORMATION_ID             NOT NULL NUMBER

 NAME                          NOT NULL VARCHAR2(30)

 FROM_TYPE                              VARCHAR2(61)

 TO_TYPE                                VARCHAR2(91)

 ATTRIBUTE                     NOT NULL NUMBER

 ATTRIBUTE_TRANSFORMATION               VARCHAR2(4000)

 

USER_AUDIT_OBJECT: Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user

 

iSelfSchooling-SQL> desc USER_AUDIT_OBJECT;

 Name                          Null?    Type

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

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 OWNER                                  VARCHAR2(30)

 OBJ_NAME                               VARCHAR2(128)

 ACTION_NAME                            VARCHAR2(28)

 NEW_OWNER                              VARCHAR2(30)

 NEW_NAME                               VARCHAR2(128)

 SES_ACTIONS                            VARCHAR2(19)

 COMMENT_TEXT                           VARCHAR2(4000)

 SESSIONID                     NOT NULL NUMBER

 ENTRYID                       NOT NULL NUMBER

 STATEMENTID                   NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 PRIV_USED                              VARCHAR2(40)

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 SCN                                    NUMBER

 SQL_BIND                               NVARCHAR2(2000)

 SQL_TEXT                               NVARCHAR2(2000)

 

USER_AUDIT_POLICIES: All fine grained auditing policies for objects in user schema

 

iSelfSchooling-SQL> desc USER_AUDIT_POLICIES;

 Name                          Null?    Type

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

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_NAME                   NOT NULL VARCHAR2(30)

 POLICY_TEXT                            VARCHAR2(4000)

 POLICY_COLUMN                          VARCHAR2(30)

 PF_SCHEMA                              VARCHAR2(30)

 PF_PACKAGE                             VARCHAR2(30)

 PF_FUNCTION                            VARCHAR2(30)

 ENABLED                                VARCHAR2(3)

 SEL                                    VARCHAR2(3)

 INS                                    VARCHAR2(3)

 UPD                                    VARCHAR2(3)

 DEL                                    VARCHAR2(3)

 AUDIT_TRAIL                            VARCHAR2(12)

 POLICY_COLUMN_OPTIONS                  VARCHAR2(11)

 

USER_AUDIT_POLICY_COLUMNS: Users fine grained auditing policy columns in the database

 

iSelfSchooling-SQL> desc USER_AUDIT_POLICY_COLUMNS;

 Name                          Null?    Type

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

 OBJECT_SCHEMA                 NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_NAME                   NOT NULL VARCHAR2(30)

 POLICY_COLUMN                 NOT NULL VARCHAR2(30)

 

 

 

Google
 
Web web site