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 -> Re: How to disable '@' in SQL*Plus?

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

From: Charlie Edwards <charlie3101_at_hotmail.com>
Date: 29 Jan 2004 02:22:16 -0800
Message-ID: <217ac5a8.0401290222.4a959424@posting.google.com>


thtsang_yh_at_yahoo.com.hk (Anthony) wrote in message news:<4178bc57.0401282108.3d6c076f_at_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

Seems a weird thing to want to do, but ...

select '
'||'@a
'
from dual
/

CE Received on Thu Jan 29 2004 - 04:22:16 CST

Original text of this message

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