How about:

SQL> select chr(10)||'a'||chr(10) from dual;

CHR
---

a



HTH,
Brian

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

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"