OraFAQ Forum: SQL & PL/SQL » decode a range

Home » SQL & PL/SQL » SQL & PL/SQL » decode a range

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

decode a range [message #19947]

Fri, 19 April 2002 13:52

Rob
Messages: 70
Registered: January 2000

Member

How would I decode a field, using a range...ie

if var1 between 5000 and 7000 then var1 = 1
else var1 = 2

Thanks, Rob

Report message to a moderator

Re: decode a range [message #19952 is a reply to message #19947]

Fri, 19 April 2002 17:06

Cindy
Messages: 88
Registered: November 1999

Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:182291::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:371900104221,%7Bdecode%7D%20and%20%7Brange%7D%20and%20%7Bsign%7D

Report message to a moderator

Re: decode a range [message #19954 is a reply to message #19952]

Sat, 20 April 2002 09:49

karen
Messages: 19
Registered: January 2002

Junior Member

Try this.

decode(sign(var1-5000),-1,'Does not meet minimum value requirement',decode(sign(var1-7000),1,'Does not meet maximum value requirement','Var1 is in range'))

Report message to a moderator

Re: decode a range [message #19976 is a reply to message #19947]

Mon, 22 April 2002 09:59

Rob
Messages: 70
Registered: January 2000

Member

Thanks ladies.

Report message to a moderator

Previous Topic:	How to create table in Stored Procedure?
Next Topic:	Converting format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 00:14:43 CDT 2024