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

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1075354681.632738_at_yasure>...
> 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
>
> SELECT keyword
> FROM v$reserved_words
> WHERE LENGTH(keyword) = 1;
>

Does that show the SQL*Plus "@" alias for START, the "@" that separates the connection identifier in a connection string, or the "@" in a database link?

Hint: it's not likely to be the first, which purely a client-side command.

• CJ