Re: [Nolug] bash problem

How bout variable expansion with curly brackets? Like ${MY_VAR}

http://stackoverflow.com/questions/8748831/bash-why-do-we-need-curly-braces-in-variables

Jess

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

> 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