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

Hallo Khamis!

Try:
set define # -- any special character other than & set scan off

Stefan.

Dipl.-Informatiker Khamis Abuelkomboz <khamis_at_knuut.de> schrieb in im Newsbeitrag: 39E2019C.333D9669_at_knuut.de...
> 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?
>
>
> thanks
>
Received on Mon Oct 09 2000 - 14:26:02 CDT