OraFAQ Forum: SQL & PL/SQL » Cursor Program To Find Tax Amount

Home » SQL & PL/SQL » SQL & PL/SQL » Cursor Program To Find Tax Amount

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cursor Program To Find Tax Amount [message #659925]

Sun, 05 February 2017 14:45

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

Report message to a moderator

Re: Cursor Program To Find Tax Amount [message #659928 is a reply to message #659925]

Sun, 05 February 2017 15:18

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Click

Report message to a moderator

Re: Cursor Program To Find Tax Amount [message #659943 is a reply to message #659925]

Mon, 06 February 2017 01:00

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Reclick.

Report message to a moderator

Re: Cursor Program To Find Tax Amount [message #659971 is a reply to message #659943]

Mon, 06 February 2017 15:02

Bill B
Messages: 1971
Registered: December 2004

Senior Member

here is a hint. Look at the case statement or the decode statement

Report message to a moderator

Previous Topic:	Function To Reverese The Phone Number
Next Topic:	DBLinks stopped after wrongly changing domain name in sqlnet.ora

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:10:56 CDT 2024