Re: How to mask the character "&" to insert it as data??

>
> I'm trying to execute a command like
>
> INSERT INTO employee VALUES ('C&La Deutsche Revision', ....)
>
> You know that & is for place holders so that SQL/Plus asks me to enter
> the
> placeholder "La".
>
> how can I mask it?

You can redefine the substitution character (default '&') with

set define <character> like

set define #

to set it back to the default:

set define &

Regards, Stephan

-- 
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Solutions GmbH
fon: +49 30 549932-0           | Landsberger Allee 366
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------