Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to disable '@' in SQL*Plus?

How to disable '@' in SQL*Plus?

From: Anthony <thtsang_yh_at_yahoo.com.hk>
Date: 28 Jan 2004 21:08:11 -0800
Message-ID: <4178bc57.0401282108.3d6c076f@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 Wed Jan 28 2004 - 23:08:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US