Re: [Nolug] bash problem

sorry I typed that in wrong. I checked and it is corrcet. but it still
won't run???
errors

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> SP2-0734: unknown command beginning "#select us..." - rest of line
ignored.
SQL> SP2-0042: unknown command "#exit" - rest of line ignored.
SQL> SP2-0042: unknown command "#EOF" - rest of line ignored.
SQL> SQL> SQL> SQL> 2 3 4 SP2-0734: unknown command beginning "and
round ..." - rest of line ignored.

On Fri, Jul 26, 2013 at 11:00 AM, Brad Bendily <bendily@gmail.com> wrote:

> 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
Received on 07/26/13