select case when sum(case when table_row_count = input_record_cnt then 1 else 0 end) = count(*)
            then 1 else 0
       end as x
  from t1
 where insert_date = trunc(sysdate);

$ 
$ 
$ cat -n generate_report.sh
     1	#!/usr/bin/ksh
     2	
     3	sqlplus -s user/pswd@db <<EOF
     4	set feedback off trimspool on
     5	set linesize 2000
     6	set newpage 0
     7	set pagesize 0
     8	set wrap on
     9	set echo off
    10	set verify off
    11	set time off timing off
    12	whenever sqlerror exit failure
    13	whenever oserror exit failure
    14	alter session enable parallel dml;
    15	spool output.txt
    16	SELECT 'LOAD_DATE SOURCE_NAME COUNTS_MATCHING'
    17	  FROM dual
    18	UNION ALL
    19	SELECT load_date || ' ' || source_name || ' ' ||
    20	       CASE WHEN table_row_count = input_record_cnt THEN 'Yes' ELSE 'No' END
    21	  FROM t1
    22	 WHERE insert_date = TRUNC(SYSDATE);
    23	spool off
    24	spool all_counts_match.txt
    25	select case when sum(case when table_row_count = input_record_cnt then 1 else 0 end) = count(*)
    26	            then 1 else 0
    27	       end as x
    28	  from t1
    29	 where insert_date = trunc(sysdate);
    30	spool off
    31	exit
    32	EOF
    33	
    34	if [[ $(cat all_counts_match.txt) -eq 1 ]]; then
    35	    mail_subject="Load counts match for $(date '+%d/%m/%Y')"
    36	else
    37	    mail_subject="Warning: Load counts do not match for $(date '+%d/%m/%Y')"
    38	fi
    39	echo "mail -s \"$mail_subject\" sk@xyz.com < output.txt"
    40	
$ 
$ 
$ . generate_report.sh
LOAD_DATE SOURCE_NAME COUNTS_MATCHING
01-JAN-17 SRC_1 Yes
01-FEB-17 SRC_2 Yes
01-MAR-17 SRC_3 Yes
	 1
mail -s "Load counts match for 13/03/2017" sk@xyz.com < output.txt
$ 
$ 
$ # After making a change in the data of the Oracle table so that the counts do not match...
$ 
$ . generate_report.sh
LOAD_DATE SOURCE_NAME COUNTS_MATCHING
01-JAN-17 SRC_1 Yes
01-FEB-17 SRC_2 No
01-MAR-17 SRC_3 Yes
	 0
mail -s "Warning: Load counts do not match for 13/03/2017" sk@xyz.com < output.txt
$ 
$