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

0 vote134 views1 answer
How to query without duplicate rows in sql
SQL
10 votes127 views1 answer
Oracle view dependencies
SQL
0 vote174 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote144 views1 answer
Truncate a table then insert data
SQL
20 votes141 views6 answers
Mysql reset auto increment
SQL
0 vote80 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
1 vote126 views1 answer
How to install mysql 8.0 windows service
SQL
-1 vote127 views5 answers
Not in sql
SQL
1 vote140 views1 answer
Sql to mongodb query converter
SQL
23 votes136 views1 answer
How remove column in mysql
SQL