VIEW: HR.HR_AUDITS#

Source

View Text - Preformatted

select AUDIT_ID AUDIT_ID, COMMIT_ID COMMIT_ID, CURRENT_SESSION_ID CURRENT_SESSION_ID, PRIMARY_KEY PRIMARY_KEY, PRIMARY_KEY_VALUE PRIMARY_KEY_VALUE, SEQUENCE_ID SEQUENCE_ID, SESSION_ID SESSION_ID, TABLE_NAME TABLE_NAME, TIMESTAMP TIMESTAMP, TRANSACTION TRANSACTION, TRANSACTION_TYPE TRANSACTION_TYPE, USER_NAME USER_NAME, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE from "HR"."HR_AUDITS"

View Text - HTML Formatted

SELECT AUDIT_ID AUDIT_ID
, COMMIT_ID COMMIT_ID
, CURRENT_SESSION_ID CURRENT_SESSION_ID
, PRIMARY_KEY PRIMARY_KEY
, PRIMARY_KEY_VALUE PRIMARY_KEY_VALUE
, SEQUENCE_ID SEQUENCE_ID
, SESSION_ID SESSION_ID
, TABLE_NAME TABLE_NAME
, TIMESTAMP TIMESTAMP
, TRANSACTION TRANSACTION
, TRANSACTION_TYPE TRANSACTION_TYPE
, USER_NAME USER_NAME
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
FROM "HR"."HR_AUDITS"