pl/sql Tutorial#22 Database trigger in oracle database

Published: 31 October 2020
on channel: EqualConnect Coach

3,136

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:
   • Tutorial#1 Basics Of Oracle SQL for B...

----------------------------------------------------------------------
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...
  / equalconnect
  / lrnwthr

Watch video pl/sql Tutorial#22 Database trigger in oracle database online without registration, duration hours minute second in high quality. This video was added by user EqualConnect Coach 31 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,136 once and liked it 52 people.

7,334