Home » SQL & PL/SQL » SQL & PL/SQL » Cursor Program To Find Tax Amount
icon4.gif  Cursor Program To Find Tax Amount [message #659925] Sun, 05 February 2017 14:45 Go to next message
Hemanth319
Messages: 3
Registered: February 2017
Junior Member
I am new to plsql and I am unable write cursor for below problem.
The data has fields like....
ename, sal, hike_percentage,...etc


Write a cursor program to calculate the net hiked salary and its tax percentage and tax amount to
be paid by each employee.
o 0 - 5000 10%
o 5001 # 10000 20%
o 10000 and above 30%


Thanks for your help
Re: Cursor Program To Find Tax Amount [message #659928 is a reply to message #659925] Sun, 05 February 2017 15:18 Go to previous messageGo to next message
Littlefoot
Messages: 21439
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Click
Re: Cursor Program To Find Tax Amount [message #659943 is a reply to message #659925] Mon, 06 February 2017 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Reclick.

Re: Cursor Program To Find Tax Amount [message #659971 is a reply to message #659943] Mon, 06 February 2017 15:02 Go to previous message
Bill B
Messages: 1802
Registered: December 2004
Senior Member
here is a hint. Look at the case statement or the decode statement
Previous Topic: Function To Reverese The Phone Number
Next Topic: DBLinks stopped after wrongly changing domain name in sqlnet.ora
Goto Forum:
  


Current Time: Sat Oct 20 01:21:20 CDT 2018