AUDIT_JOURNAL_SV table function
The AUDIT_JOURNAL_SV table function returns rows from the audit journal that contain information from the SV (Action to System Value) journal entries.
Every audit journal table function shares a common authorization requirement and a common set of parameters. These are described in AUDIT JOURNAL table function common information.
The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.
Column Name | Data Type | Description |
---|---|---|
The first columns returned by this table function are from the common audit journal entry header. See Common columns returned from the audit journal entry header for the column definitions. After the common columns are the following columns that describe the entry specific data for the SV audit journal entry. | ||
ENTRY_TYPE | CHAR(1) | The type of entry.
|
ENTRY_TYPE_DETAIL | VARCHAR(200) | Descriptive text that corresponds to the entry type. |
SYSTEM_VALUE | VARCHAR(10) | The name of the system value or service attribute
that was changed. Can contain one of the following special values.
|
OLD_VALUE | VARCHAR(1500) | The value of the system value or service attribute before it was changed. |
NEW_VALUE | VARCHAR(1500) | The new value of the system value or service attribute. |
Example
- List any system value changes that have been made in the current calendar
year.
SELECT * FROM TABLE ( SYSTOOLS.AUDIT_JOURNAL_SV (STARTING_TIMESTAMP => TRUNC_TIMESTAMP(CURRENT DATE, 'YEAR')) ) WHERE ENTRY_TYPE = 'A';