Shell Programming and Scripting

#-------------------------------------------------------------
# Log into database and execute stored procedure
#-------------------------------------------------------------
sqlplus -S myLogin/myPwd@myServer >> /tmp/myLogFile << EOF
    whenever sqlerror exit 1
    set echo off
    set pagesize 0
    set feedback off
    set trimout on
    set trimspool on
    set heading off
    SPOOL /tmp/myExpiredList
select my_id, my_expr_tmstp from MY_SCHEMA.MY_TABLE where current_timestamp > my_expr_tmstp ;                                                    
SPOOL OFF
EOF

where current_timestamp > sysdate - 1;

select my_id, my_expr_tmstp from MY_SCHEMA.MY_TABLE 
where my_expr_tmstp = trunc(current_timestamp)-1 ;