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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Convert SQL server case statement to Oracle

RE: Convert SQL server case statement to Oracle

From: Gabriel Galanternik <ggalanterni_at_tesis-oys.com.ar>
Date: Mon, 30 Oct 2000 17:47:53 -0300
Message-Id: <10665.120601@fatcity.com>


Try testing sign(valueA-valueB). If it's 1 then ValueA is greater than ValueB

HTH Gabriel


     Gabriel Galanternik
         Tesis OyS

-Que tengas un muy buen dia!-

Hi All,

I am trying to convert the following case stmt to Oracle but am stuck. I tried using DECODE but cannot
handle the <= or <. Equal or Not equal I can convert by using decode. Any ideas?

Thanks
Rick

WHEN EFF_DATE <= V_dStartDate AND END_DATE_ADJ <= V_dEndDate

   THEN COMP_LINK_EMIS_ADJ*DATEDIFF(SS,V_dStartDate ,END_DATE_ADJ)/3600*(OP_PCT/100) WHEN (EFF_DATE BETWEEN V_dStartDate AND V_dEndDate) AND END_DATE_ADJ >= V_dEndDate

   THEN COMP_LINK_EMIS_ADJ*DATEDIFF
(SS,EFF_DATE,V_dEndDate)/3600*(OP_PCT/100)

WHEN (EFF_DATE BETWEEN V_dStartDate AND V_dEndDate) AND (END_DATE_ADJ  BETWEEN V_dStartDate AND V_dEndDate)
   THEN
COMP_LINK_EMIS_ADJ*DATEDIFF(SS,EFF_DATE,END_DATE_ADJ)/3600*(OP_PCT/100) WHEN (EFF_DATE < V_dStartDate) AND (END_DATE_ADJ > V_dEndDate) THEN
COMP_LINK_EMIS_ADJ*DATEDIFF(SS,V_dStartDate,V_dEndDate)/3600*(OP_PCT/100) Received on Mon Oct 30 2000 - 14:47:53 CST

Original text of this message

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