Just post the professor's email address, and we'll email it directly to
him/her. A particularly good book (and probably a required text for your
class) is Scott Urman's PL/SQL Programming.
"kwest" <member_at_mainframeforum.com> wrote in message
news:3d625ad8$2_1_at_news5.nntpserver.com...
> 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
Received on Tue Aug 20 2002 - 12:24:32 CDT
