OraFAQ Forum: Forms » How to use between or <= on Select statement

Home » Developer & Programmer » Forms » How to use between or <= on Select statement

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

How to use between or <= on Select statement [message #180377]

Mon, 03 July 2006 05:38

anna marie
Messages: 26
Registered: June 2006
Location: Philippines

Junior Member

I'm trying to split my data into separate column,
but I'm having problem on decode function as I can't do the logic below on my select statement.

If b_date <= date1 then column1
If b_date <= date2 then column2
If b_date between (date3, date4) then column3
and so on...

Is there a way to use (between) function or (<= >=) operator in select statement?

I thank you all in advance!

Report message to a moderator