Hi I have records as follows.
Number Rows stmt
------------------------------
1001 10 select count(*) from tabs where rows<=10
now what happens is if rows<=10 it returns '0' .if it's >10 then it returns 'nothing'
Now the requirement is :
" if rows>10 i need to send a mail to any(for example... abc.ss@gmail.co m mail-id mentioned as " The statement was failed because rows>10."
I need to write "SHELL SCRIPT" for this.
So anyone please send me the script for this issue..
Thank you.
Number Rows stmt
------------------------------
1001 10 select count(*) from tabs where rows<=10
now what happens is if rows<=10 it returns '0' .if it's >10 then it returns 'nothing'
Now the requirement is :
" if rows>10 i need to send a mail to any(for example... abc.ss@gmail.co m mail-id mentioned as " The statement was failed because rows>10."
I need to write "SHELL SCRIPT" for this.
So anyone please send me the script for this issue..
Thank you.