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

2 votes129 views1 answer
Create table with primary key
SQL
22 votes141 views4 answers
Show list of users in mysql
SQL
0 vote185 views1 answer
Php insert null mysql
SQL
11 votes150 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote137 views1 answer
Case insensitive sql
SQL
0 vote143 views1 answer
Java sql connection
SQL
14 votes155 views1 answer
Oracle new column
SQL
1 vote142 views1 answer
Mysql select update same table
SQL
15 votes156 views4 answers
Pl sql
SQL
0 vote225 views1 answer
Mysql update all record removing 2 hours from column
SQL