Thursday, August 24, 2017

How to find out two date month number in oracle database



function AVG_SFTFormula return Number is
    V     NUMBER;
begin
    SELECT TRUNC(MONTHS_BETWEEN( :P_ENDDT, :P_stdt))
    INTO V
    FROM DUAL;
  
   IF V <1 br="" then="">       RETURN(0);
   ELSE
        RETURN(NVL(:TOT_SFT,0)/NVL(V,0));
   END IF;
  
  
end;


---------------
function AVG_SFTFormula return Number is
    V     NUMBER;
begin
    select 12+(to_char(MAX(TRUNC(to_date(MDATE),'RR')),'MM')-to_char(min(to_date(MDATE)),'MM'))
    INTO V
    from sales_master where slcode=:SLCODE AND MDATE BETWEEN :P_stdt AND :P_ENDDT;
  
   IF V <1 br="" then="">       RETURN(0);
   ELSE
        RETURN(NVL(:TOT_SFT,0)/NVL(V,0));
   END IF;
  
  
end;

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...