Need help with triggers!!!

I need help writing a trigger. The directions are to create a BEFORE TRIGGER on your employee table (west_employee). Update the table by increasing the payrate of all your employees by 15%. The trigger should fire once for each row that is updated. Show the old and new pay rate.

Here's what I have so far:

create or replace trigger west_bi before insert on west_employee for each row declare v_pay_rate west.pay_rate%type; begin

I'd appreciate any help I can get. Thanks, Kim

--
www.MainFrameForum.com - USENET Gateway