Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL in ksh script question

SQL in ksh script question

From: yogurt <yogurt_at_stratos.net>
Date: Mon, 12 Oct 1998 09:50:51 -0400
Message-ID: <MPG.10882703d362bfe0989681@news.supernews.com>


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 Mon Oct 12 1998 - 08:50:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US