Re: Oracle within a Unix Script

From: Thierry Poels <Thierry.Poels_at_vab.be>
Date: Tue, 19 Oct 1999 09:39:38 +0200
Message-ID: <7uh793$n9$1@news1.skynet.be>

Hi,

how about "escaping" the dollar signs ??

... from v\$filestat x, ts\$ ts, v\$datafile i, file\$ f

The best solution is already mentioned by Roy : put the SQL-statement in a seperate file.

good luck,
Thierry Poels
HP-UX Sysadmin & Oracle DBA

<amerar_at_ci.chi.il.us> wrote in message news:7ufdtu$l21$1_at_nnrp1.deja.com...
> Hello,
>
> I have a simple Unix script that logs onto SQL and executes some SQL to
> spool to a file. Here is a clip:
>
> sqlplus -s /<< EOT 1>/dev/null
> .
> .
> select .....
> .
> .
> from v$filestat x, ts$ ts, v$datafile i, file$ f
> .
> .
>
> The problem is that the Unix script is taking those $ signs and thinks
> they are variables. Is there a way for me to escape them so Oracle will
> still recognize them???
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 19 1999 - 02:39:38 CDT