OPA, faltou truncar a data no agrupamento e extender para aceitar os registros
recebidos até as 23:59 do ultimo dia.
SELECT trunc(DTSAIDA,)
SUM(CASE when upper(nvl(substr(regexp_replace(SERIE,
'[[:punct:]]|[[:blank:]]|[0-9]'),1,2),'xx')) = 'CF' THEN VLTOTAL ELSE 0 END)
CF,
SUM(CASE when upper(nvl(substr(regexp_replace(SERIE,
'[[:punct:]]|[[:blank:]]|[0-9]'),1,2),'xx')) != 'CF' THEN VLTOTAL ELSE 0 END)
NOCF
FROM PCNFSAID N
WHERE 1 = 1
AND DTSAIDA BETWEEN to_date('01/SEP/2014', 'DD/MON/YYYY') AND
TO_DATE('10/SEP/2014', 'DD/MON/YYYY')+0.99999
GROUP BY trunc(DTSAIDA)
ORDER BY 1;
Ederson Elias
DBA Oracle - http://br.linkedin.com/pub/ederson-elias/24/8b/8b0
------------ Labor improbus omnia vincit
