In a txt file called, eso.txt, I have:
PHP Code:
......
3 where process_status_flag = 70 and LISTENER_ID in (930.00, 931.00, 932.00, 933.00, 934.00)
4 group by LISTENER_ID
5 order by LISTENER_ID;
LISTENER COUNT
---------- ----------
930 5145
931 5344
932 5387
933 5517
934 4942
SQL>
SQL> spool off
I need to grep the below if any of LISTENER has more than 5,500 on COUNT and e-mail out to me.
PHP Code:
LISTENER COUNT
---------- ----------
930 5145
931 5344
932 5387
933 5517
934 4942
So, in this case, LISTENER 933 has more than 5,500 COUNT, I need to e-mail it out the entire of this.
PHP Code:
LISTENER COUNT
---------- ----------
930 5145
931 5344
932 5387
933 5517
934 4942
Please advise.