Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to insert a ' into an field
Answer embedded.
-- Have a nice day Michel Oliver Huppert <ohuppert_at_pikon.com> a écrit dans le message : 39e2fa9a_at_news.netfab.de...Received on Tue Oct 10 2000 - 07:33:41 CDT
> Hi there
>
> I've to insert a String conaining a ' into an table.
> The SQL-Statement:
>
> insert into [table] values ('14 jours après l'implantation');
double the apostrophe: insert into [table] values ('14 jours après l''implantation');
>
> or so
>
> don't work, because of the ' after the l. Oracle means the String ends here.
>
> Plsease help me.
>
> Nice regards
> Oliver Huppert
>
>
![]() |
![]() |