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 vote346 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote346 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote413 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
18 votes321 views2 answers
Sql inner join
SQL
0 vote388 views1 answer
Virtuoso sql query tutorial
SQL
0 vote338 views1 answer
Dump multiple tables mysql
SQL
0 vote359 views3 answers
Postgres date difference seconds
SQL
0 vote363 views1 answer
Sql sum show 0 result
SQL
13 votes347 views4 answers
Command line mysql import
SQL
0 vote375 views1 answer
Google sheets data validation custom formula filter
SQL