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

On this page of the site you can watch the video online pl/sql Tutorial#22 Database trigger in oracle database with a duration of hours minute second in good quality, which was uploaded by the user EqualConnect Coach 31 October 2020, share the link with friends and acquaintances, this video has already been watched 3,136 times on youtube and it was liked by 52 viewers. Enjoy your viewing!

1,572