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

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_at_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"