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

Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with ampersand

Re: problem with ampersand

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 21 May 2004 20:04:28 GMT
Message-ID: <ghtrc.4732$SQ2.2678@edtnps89>


Ford Desperado wrote:

> which means I'm getting 'L1' instead of the 'L&L' token that I need.
> Although I already have a workaround, I'm quite curious why would that
> happen
>
 

& is normally the character used to define a 'substitution variable'. Basically you are telling your environment "se L concatenated with the value found in subs. var 'L'"

This is basic SQLPlus stuff. You might want to spend a bit more time in the SQLPlus Reference manual as there are a whole pile of other useful & time saving features you have likely missed.

/Hans Received on Fri May 21 2004 - 15:04:28 CDT

Original text of this message

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