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 vote158 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote123 views1 answer
Psql filed name alter
SQL
5 votes134 views2 answers
Oracle show procedures
SQL
0 vote117 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
9 votes152 views3 answers
Date format in sql
SQL
1 vote131 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote246 views2 answers
Postgres select from last 3 months
SQL
4 votes142 views3 answers
Mysql get column names from table
SQL
0 vote88 views1 answer
Oracle sql replace string in clob
SQL
0 vote136 views2 answers
Athena drop partition
SQL