♥ tugas 7 DBMS ♥

DBMS 7 [ TRIGGER ]

Nama    : Irma Santikarama

Kelas     : PIS 0904

NIM       : 30108255

create or replace trigger nama_trigger

timing   --> isinya before, after, instaead of

event1 or event2 or event3    -->insert, update, delete, logon, logoff

ON nama_objek   --> nama tabel, nama user, database

begin

...

end;

/

Contoh trigger

create or replace trigger anulogin

after

logon

on database

begin

insert into rekaman values(user, sysdate, sysdate, 'login dari database');

dbms_output.put_line('haloo '||user);

end;

/

create or replace trigger anuinsert

after

insert

on regions

for each row

begin

insert into rekaman values(user,sysdate,sysdate,

'tambah data ke tabel regions dengan id '||:new.region_id);

end;

/