Home » SQL & PL/SQL » SQL & PL/SQL » calculates the deduction sal
calculates the deduction sal [message #21806] Sun, 01 September 2002 17:32 Go to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
dear hay;
adaab
i was preparing a software which name is attendance ,where i require this to caluclate salary sheet .if the employee has two leaves it will recieve full sal.if the employee has three or more leaves then it will charged deduction pay.Please response me as soon as possible.
example
Acsal totaldays work days cal sal
7000 31 30 7000
6800 31 20 6800 *20/31 =
please send me code of this how i can escape the 2 days and employee get full pay and the other will face deduction pay;
thanks
shah1419@yahoo.com
Re: calculates the deduction sal [message #21810 is a reply to message #21806] Sun, 01 September 2002 22:47 Go to previous message
Puneet Vats
Messages: 33
Registered: June 2002
Member
Dear ,
I think u can do it with coding in any pl/sql block;
ok bye
Previous Topic: Sql Query to retrive Priamry Foreign Key field of Table
Next Topic: Oracle 11
Goto Forum:
  


Current Time: Fri Apr 26 04:38:50 CDT 2024