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

Anthony wrote:

> 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

SELECT keyword
FROM v$reserved_words
WHERE LENGTH(keyword) = 1;

Don't try to kludge your way around a bad design ... fix your design.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)