Oracle within a Unix Script

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 Mon Oct 18 1999 - 10:21:45 CDT