SET TRIMSPOOL ON;
	SET ECHO OFF;
	SET TRIMOUT ON;
	SET LINESIZE 50;
	SET PAGESIZE 0; 
	SET FEEDBACK OFF;
	SET colsep '|'
	SET TIMING OFF;
	SET HEADING OFF;
	SET VERIFY OFF;
	SET TERMOUT OFF;
	SPOOL d:/Temp/1/export_file.csv;
	whenever oserror exit 1
	whenever sqlerror exit 2

SELECT *
FROM
     (SELECT to_char(date_of,'yyyy.mm.dd') "Дата", ID_DIVISION, DECODE (amount,'0',operation,amount) as new_amount 
      FROM t_data where 
      DATE_OF >= TO_DATE('01.07.2018 00:00:00','dd.mm.yyyy hh24:mi:ss') 
      AND 
      DATE_OF <= TO_DATE('29.07.2018 23:59:59','dd.mm.yyyy hh24:mi:ss')
     ) PIVOT (count(new_amount) AS "Кол-во",SUM(trunc(new_amount)) AS "Сумма"
              FOR ID_DIVISION IN (2600001000, 2700001000, 100001000
                )
               )
ORDER BY 1;

SPOOL OFF;
exit 0;

SELECT *
FROM
     (SELECT to_char(date_of,'yyyy.mm.dd') "Дата"||';'|| ID_DIVISION||';'|| DECODE (amount,'0',operation,amount) as new_amount 
      FROM t_data where 
      DATE_OF >= TO_DATE('01.07.2018 00:00:00','dd.mm.yyyy hh24:mi:ss') 
      AND 
      DATE_OF <= TO_DATE('29.07.2018 23:59:59','dd.mm.yyyy hh24:mi:ss')
     ) PIVOT (count(new_amount) AS "Кол-во",SUM(trunc(new_amount)) AS "Сумма"
              FOR ID_DIVISION IN (2600001000, 2700001000, 100001000
             ))
ORDER BY 1;