set markup csv on delimiter ';' quote off 

set embedded on
set verify off
set feedback off
set echo off
set termout off
set term off
set heading off
set trimout on
set trimspool on
set pagesize 0
set linesize 2000
whenever sqlerror exit failure;
alter session set optimizer_mode=all_rows;
alter session set nls_numeric_characters = '. ';

variable row_cnt number;

column row_cnt_col NEW_VALUE row_cnt;

spool out.csv

select 
	t.*,
	count(*) over() AS row_cnt_col
from 
(
select
       1
||';'||2
||';'||t.source_file_id
||';'||t.id
||';'||t.source_group_id
||';'||t.service_date
||';'||t.device
||';'||t.detail
||';'||t.service_count
||';'||t.service_count1
||';'||t.service_count2
||';'||t.service_count3
||';'||t.order_date
||';'||t.report_date_id
||';'||t.town_id
||';'||t.device_group_id
||';'||t.abonent_id
||';'||t.abonent_group_id
||';'||t.detail_type_id
||';'||t.tariff_type_id
||';'||t.service_pack_type_id
||';'||t.factor_type_id
||';'||t.date_factor_type_id
||';'||t.nds_type_id
||';'||t.discount_type_id
||';'||t.service_count_group_id
||';'||t.debit
||';'||t.tdr_group_id
||';'||t.bill_type_id
||';'||t.dbill_type_id
||';'||t.bill_id
||';'||t.vat_rate
||';'||t.personal_discount
||';'||t.discount_amt
||';'||t.day_type
||';'||t.period_name
||';'||t.rpr9_usage_interface_id
||';'||t.event_id
||';'||t.subscriber_id
||';'||t.user_name
from db.tdr t, db.bill b
where t.bill_id=b.id and
      t.report_date_id=b.report_date_id and
      b.report_date_id=extract(month from to_date('10.01.2019', 'dd.mm.yyyy')) and
      trunc(t.order_date) = to_date('10.01.2019', 'dd.mm.yyyy')) t;

spool off;

execute :row_cnt := &row_cnt;

spool out.crc

print row_cnt;

spool off;

exit;