Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compiling pl/sql in sqlplus with an @ char within the code?
In article <44881e50$0$4496$9b4e6d93_at_newsread2.arcor-online.net>, Maxim
Demenko says...
> Jeremy schrieb:
> > In article <448814db$0$11078$9b4e6d93_at_newsread4.arcor-online.net>, Maxim
> > Demenko says...
> >> It seems, sqlplus gets broken on the first nonwhitespace "@" character (
> >> regardless it is quoted).
> >>
> >
> > I had also been wondering if there was a "set" statement I could use in
> > sqlplus to alter the defaults (e.g. the define is usually the & char)
> >
> > e.g.
> >
> > SQL> set define {
> > SQL> set runscript }
> >
> > (I made the second one up for illustrative purposes)
> >
>
> I don't quite understood your question,
> clearly you can reassign the default '&' for substitution variables to
> another character or disable substitution behaviour at all (and after
> your script is run reenable it)
Exactly - and I was wondering if there was a similar option for changing the @ character for something else. Or as you say disable at start of script and re-enable at end.
> See
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#sthref2736
>
cheers
-- jeremyReceived on Thu Jun 08 2006 - 08:16:28 CDT