SQL in ksh script question

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