Re: SQL in ksh script question

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Tue, 13 Oct 1998 12:44:55 +0100
Message-ID: <36233D37.10AFD523@DeutschePost.de>

Hi,

quoting the EOF-marker will supress any variable substitions in a here - shell script:
in Korn/Bourne-Shell

svrmgr <<\EOF
select * from v$session;
exit
EOF in C-Shell:

svrmgr <<\EOF
select * from v$session;
exit
\EOF Torsten Borchert

yogurt wrote:
>
> When I try to execute the following SQL from within a ksh script,
> the "$" (dollar sign) in v$sqlarea causes a problem, because
> the korn shell interprets it as a variable and the SQL fails:
>
> select substr(sql_text,1,30) sql , count(*)
> from v$sqlarea;
>
> Your help is appreciated.
>
> Dale
> yogurt_at_stratos.net
Received on Tue Oct 13 1998 - 06:44:55 CDT