Re: views can not be use in a script

From: Régis Le Bretonnic <rlebretonnic_at_webmail.alten.fr>
Date: Fri, 1 Jun 2001 10:14:07 +0200
Message-ID: <9f7k7a$jkl$1@reader1.fr.uu.net>

once i did something like that :

DOLLAR="\$"    SQLPROMPT1=`svrmgrl <<endl | egrep "SEQUENCE|ORA"

      connect internal;
      set charwidth 200
      alter system switch logfile;
      select 'SEQUENCE:'||sequence# title from v${DOLLAR}log where
status='CURRENT';
      alter tablespace $1 begin backup;
      exit;

   endl`

Cordialement.

   Régis Le Bretonnic
   em_at_il : rlebretonnic_at_webmail.alten.fr

"Antony Mak" <cheong_at_broadway-ps.com> a écrit dans le message news: 3b1721b4_at_newsgate.imsbiz.com...
>
> Hi all,
>
> I have problem when using v$ views in a shell script running at
 background
> (the "$" sign cannot interpreter by shell). Does anyone have
 experience on
> using "$" sign in a shell script.
>
> Antony
> --
> antony_at_broadway-ps.com
>
>
Received on Fri Jun 01 2001 - 03:14:07 CDT