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 do to insert '&' character from sqlplus ?

Re: How do to insert '&' character from sqlplus ?

From: Cyril Schmidt <tweng_at_mailinator.com>
Date: 9 Jul 2004 01:32:56 -0700
Message-ID: <81fe516a.0407090032.1ae01881@posting.google.com>


When the ampersand is the *last* character of a string literal, sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Received on Fri Jul 09 2004 - 03:32:56 CDT

Original text of this message

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