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

Dipl.-Informatiker Khamis Abuelkomboz wrote:
>
> 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

set define off

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.