Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DECODE OR CASE

DECODE OR CASE

From: Oracle Newbie <f93c0532_at_yahoo.com>
Date: Fri, 2 Jul 2004 11:41:05 +0500
Message-ID: <2kkeb3F3d8cjU1@uni-berlin.de> 





How is it possible to use the DECODE function or CASE statement to implement
some thing like this



If  salary >= 1200 and salary < 1300 then


        grade := 1;


elsif salary >= 1300 and salary < 1500 then


        grade := 2;


elsif salary >= 1500 and salary < 2000 then


        grade := 3;


else


        grade := 4;



end if ;
Received on Fri Jul 02 2004 - 01:41:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US