Re: [Nolug] bash problem

thanks for the info. but I did try , still no luck.

SELECT username, expiry_date
from dba_users
where username = ${TARGET_ACCOUNT}
#and round (expiry_date - sysdate < 11);
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.
by the way, it works up to the from dba_users., but when I add the where
username......
I get those errors.

Thanks for checking

Barbara
On Fri, Jul 26, 2013 at 11:37 AM, Jess Planck <jesse.planck@gmail.com>wrote:

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