Re: Inserting a & into a table

you may also use quotes around "&", for example:

insert into a (rating_company) values ('S' || '&' || 'P');

Jens Lundell wrote in message <3522D145.504BCE55_at_cpmx.saic.com>...
>This seems to be an SQL*Plus issue.
>A simple insert works fine using SQL Worksheet and OCI but SQL*Plus
>interpretes the & as a prefix for a parameter.
>
>Regards,
> Jens
Received on Fri Apr 03 1998 - 00:00:00 CST