Oracle compile trigger

Oracle trigger

CREATE OR REPLACE TRIGGER my_schema.trigger_name AFTER LOGON ON DATABASE
BEGIN
    INSERT INTO my_log_table
    VALUES (USER AS CONNECTED_USER,
        sys_context('USERENV', 'SESSIONID') AS SESSION_ID,
        substr(sys_context('USERENV', 'OS_USER'), 1, 50) AS OS_USER,
        substr(sys_context('USERENV', 'HOST'), 1, 30) AS HOST,
        SYSDATE AS LOGON_DATE);
END;
ALTER TRIGGER my_schema.trigger_name ENABLE;

Oracle compile trigger

alter trigger MY_SCHEMA.TRIGGER_NAME compile;

Similar codes

3 votes112 views1 answer
Oracle revoke
SQL
0 vote118 views1 answer
Sql mod even odd
SQL
2 votes78 views1 answer
Sql float to int
SQL
3 votes121 views2 answers
Mysql config user password
SQL
3 votes115 views2 answers
How to load files in mysql
SQL
2 votes114 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote120 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote125 views1 answer
Sql constarint
SQL
0 vote125 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
1 vote123 views1 answer
Oracle list data files
SQL