Minus operator in the batch file
Hi Hope i am not making u understand
spool num.log
select max(sequence#) from v$log_history@orcl1 minus select max(sequence#) from v$log_history@orcl2;
spool off
This had generated num.log with a value 80
So how can i read the value 80 in the file num.log and assign it to a variable sum
and then had a expression like where sum>80 ( In the batch file )
Thank you in advance
spool num.log
select max(sequence#) from v$log_history@orcl1 minus select max(sequence#) from v$log_history@orcl2;
spool off
This had generated num.log with a value 80
So how can i read the value 80 in the file num.log and assign it to a variable sum
and then had a expression like where sum>80 ( In the batch file )
Thank you in advance
0