I am a novice at plsql:

can you help me write the following ddl?

creater trigger name qoh_update that is associated with order_line table and correctly adjusts the inv_qoh filed in the invetory_Table whenever the ol_quantity field is updated for associated invetory item..

here is my ddl

create or replace trigger qoh_update
after insert on order_line
for each row
begin
update inventory
--set inv_qoh = ol_quantity;
where inv_qoh =

--where inv_id = :new.inv_id;
end;
/