How to disable '@' in SQL*Plus?

Giganews Newsgroups
Subject: How to disable '@' in SQL*Plus?
Posted by:  thtsang_…@yahoo.com.hk
Date: 28 Jan 2004

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

Replies