--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
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;1>1>
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...
No comments:
Post a Comment