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 vote348 views1 answer
Vbscript connect mssql
SQL
1 vote312 views1 answer
Count of tables in database mysql
SQL
2 votes318 views1 answer
Date_format for time sql
SQL
1 vote334 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote314 views1 answer
Select from one table where not on the other
SQL
27 votes347 views5 answers
Mysql set password for user
SQL
4 votes310 views1 answer
Wilayah indonesia sql
SQL
0 vote334 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote328 views2 answers
Laravel get sql query eloquent with parameters
SQL
15 votes319 views4 answers
T-sql drop function if exists
SQL