Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01756: quoted string not properly terminated
Try, insert into TB_DIVISION values ('MOHQ','MARK'||''''||'S OFFICE')
In article <73icc0$ua5$1_at_nnrp1.dejanews.com>,
hpcheong_at_ncs.com.sg wrote:
> hi all,
>
> when i am try to do this
>
> insert into TB_DIVISION values ('MOHQ','MARK'S OFFICE');
>
> i am getting ORA-01756: quoted string not properly terminated. apparently,
> the system took the quote that is in mark's as the closing quote. can anyone
> tell me how should i go about in order to allow such kind of insertion.
>
> thanks in advance...
>
> evelyn.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 26 1998 - 08:03:47 CST