Home » SQL & PL/SQL » SQL & PL/SQL » Re: Need to implement this business rule for triggers
Re: Need to implement this business rule for triggers [message #38814] Thu, 16 May 2002 11:41
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
SriDHAR, Sid could confirm this, but I am assuming here that comm (commission) is a column that will accumulate over time as the salesperson makes sales.

update empy
   set comm = comm + p_commission_on_new_sale
 where id = p_employee_id;


A non-salesperson should never have a value in this column.

Report message to a moderator

Previous Topic: HELP! variable in global temporary table
Next Topic: Re: wild card filtering
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 17:53:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.