[ASK] Trigger oracle
 

gan ane maw tanya ,

ane punya table




Spoiler for table:




create table member (

id_member varchar (20) primary key not null,

saldo_member number);



create table buku (

id_buku varchar (20) primary key not null,

jumlah_buku number default 0);



create table pinjam(

id_pinjam varchar (20) primary key not null,

id_member varchar (20) not null,

id_buku varchar (20) not null,

biaya_pinjam number,

jumlah_pinjam number,

foreign key (id_member) references member (id_member),

foreign key (id_buku) references buku (id_buku));











ane maw bikin trigger,

jika terjadi insert di table pinjam,

maka biaya_pinjam - saldo_member

jumlah_pinjam - jumlah_buku



ane dah bikin tp binggung ketika biaya_pinjam - saldo_member gan,

gmana yak , mhon bimbingannya

</div>