[Nolug] bash problem

I am a newbi and I have a problem trying to run this code. I am trying to
put a unix variable - (Target_account)
into a bash/unix scritpt. If anyone could help I would appreciate it.

Thanks
diann
 #!/bin/bash

TARGET_ACCOUNT=TORY4
TARGET_DATABASE=testbat
RS=samp.lst
. ${MMS_LOCAL}/etc/env_testbat.sh
echo SID=$ORACLE_SID
sqlplus / ' as sysdba' <<EOF

SELECT username, expiry_date
from dba_users
where username = $TARGET_ACOUNT
and round (expiry_date - sysdate < 11);
EOF

___________________
Nolug mailing list
nolug@nolug.org
Received on 07/26/13