"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA702883C34_at_lnewton.leeds.lfs.co.uk...
> Hi Daniel,
>
> if that was a homework question, I'd hate to be in his/her class - it
> makes absolutely no sense to update someone's pay rate by 15% every time
> the employee record is updated. Minsd you, I could do with that sort of
> thing being in operation here :o)
Its a classic homework question (though admittedly the table is
west_employee not emp).
surely the trigger updates hr payscales everytime meaningless updates are
made to hr tables.....
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Aug 20 2002 - 14:11:19 CDT
