Use Oracle date function to implement alert in shell script

  1         Practice: calculate diff of DB time column in shell script 1.1        Practice: check_diff_time.sh oracle@oraclevm01: /monitoring/bin  % : more check_diff_time.sh #!/bin/bash lag=$(sqlplus -s  TESTUSER/oracle@pstg <<END set pagesize 0 feedback off verify off heading off echo off; select ROUND(TO_NUMBER(cast(target_commit as date)-cast(source_commit as date))*24*60) as lag_time from TESTUSER.HEARTBEAT exit; END ) echo $lag   https://unix.stackexchange.com/questions/85180/assigning-the-output-of-a-sql-query-to-variable https://stackoverflow.com/questions/17774405/bash-sql-query-outputs-to-variable […]