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 vote172 views1 answer
Show create table in postgresql
SQL
3 votes187 views1 answer
Oracle transaction commit rollback example
SQL
0 vote181 views1 answer
Original Query
SQL
1 vote188 views1 answer
Postgresql float 2 decimal places
SQL
0 vote177 views2 answers
Postgres default user
SQL
1 vote187 views2 answers
Sql where is not number
SQL
0 vote184 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote189 views1 answer
Mysql dump for selected row
SQL
0 vote197 views1 answer
Time data type in mysql
SQL
0 vote212 views1 answer
Insufficient privileges while creating view in sql oracle
SQL