Hi
I have PL/SQL Function body returning a SQL statement under Oracle APEX 20.1. It returns a value, but for dates where there are no values I would like that it returns a null value.
RETURN '
SELECT trunc(DATE1) HO,
ROUND(AVG(VALEUR),2) HIGH
FROM ' || dbms_assert.sql_object_name('EVV_' || coalesce(:P7_TABLE_TELEGESTION, 'D34')) || '
WHERE DATE1 BETWEEN TO_DATE('''||:P7_DATE_DEBUT||'000000'', ''DD/MM/YYYYHH24MISS'') AND TO_DATE('''||:P7_DATE_FIN||'235959'', ''DD/MM/YYYYHH24MISS'')
AND CLEF_VAR = '''||:P7_DEB_NON_VAL||'''
GROUP BY trunc(DATE1)
ORDER BY trunc(DATE1)';
For example it will returns this kind of data :
02/11/2020 0
03/11/2020 null
04/11/2020 null
05/11/2020 null
06/11/2020 0
07/11/2020 0
...
How to do this ? I am under Oracle 12.1
Reagrds,
Christian