Horje
oracle compile trigger Code Example
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;



Sql

Related
add column to all tables after first column mysql Code Example add column to all tables after first column mysql Code Example
select * from mysql.proc Code Example select * from mysql.proc Code Example
in sql developer where equal queres Code Example in sql developer where equal queres Code Example
sql distinct only one column Code Example sql distinct only one column Code Example
What is the library that should import to use all functional database features in SQLite? Code Example What is the library that should import to use all functional database features in SQLite? Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje