Oracle SQL beginner tutorials With exercise/ Database Basic to Advance Training - pl/sql Tutorial#22 Database trigger in oracle database

In pls/sql tutorial we are going to learn how to write database trigger in oracle pls/sql database Oracle SQL Complete Tutorial/Training/Course for the beginner: https://www.youtube.com/watch?v=3v4s3XMw4q0&list=PLiLpmqwkwkCt0QeXD8j7BwIoOaBGBRrZC ---------------------------------------------------------------------- Example of database trigger in sql / plsql ---------------------------------------------------------------------- CREATE or REPLACE TRIGGER trg_logon AFTER LOGON ON DATABASE ENABLE DECLARE event_Type VARCHAR2(15); object_Type VARCHAR2(15); object_name VARCHAR2(15); begin event_Type := ora_sysevent; object_Type := ORA_DICT_OBJ_TYPE; object_name := ora_dict_obj_name; insert into schema_audit values(sysdate,sys_context('USERENV','CURRENT_USER'), event_Type,object_Type,object_name); end; follow me on: Facebook Page: https://www.facebook.com/Equalconnect-Coach-791404517889358/?modal=admin_todo_tour https://www.instagram.com/equalconnect/ https://twitter.com/LrnWthR