Re: [Nolug] bash problem

>From your code, you left out an C in account.
"where username = $TARGET_ACOUNT"

On Fri, Jul 26, 2013 at 10:51 AM, Diann Smith <diann170@gmail.com> wrote:

> 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
>

-- 
Have Mercy & Say Yeah
___________________
Nolug mailing list
nolug@nolug.org