Re: ORA-01756: quoted string not properly terminated

Evelyn,
Try this
insert into TB_DIVISION values ('MOHQ','MARK''S OFFICE');

Regards,
Rudy Suciato
Beginners DBA

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
Received on Thu Nov 26 1998 - 05:18:33 CST