Re: How to disable '@' in SQL*Plus?

From: Merci <msmith_at_whi.org>
Date: Fri, 30 Jan 2004 11:04:33 -0800
Message-ID: <bve9s9$lhg$1@lists.fhcrc.org>

Can you replace the offending @ ?

select chr(64)||'a' from dual;

"Anthony" <thtsang_yh_at_yahoo.com.hk> wrote in message news:4178bc57.0401282108.3d6c076f_at_posting.google.com...
> I would like to execute a SQL script similar to following in sqlplus:
>
> (test.sql)
> select '
> @a
> '
> from dual;
>
> SQL*plus attempted to execute a script called a.sql and this fails:
>
> SQL> @test.sql
> SP2-0310: unable to open file "a.sql"
>
> ''
> --------------------------------
>
>
> Is there any method to disable SQL*plus from interpreting the @
> chacter as the start command and execute a script?
>
> (The expected output of the sql is as follows. Seems 'ed'iting SQL can
> disable the @:
>
> SQL> ed
> Wrote file afiedt.buf
>
> 1 select '
> 2 @a
> 3 '
> 4* from dual
> SQL> /
>
>
> @a
> ----------------------------------------------------------------
>
> @a
>
>
> )
>
> Thanks very much in advance
Received on Fri Jan 30 2004 - 13:04:33 CST