insert single quotes

[BASSUHG]

Hello every one

I am trying to insert text into oracle 10g, which contains ( ‘ ) single quotes.

I know its simple , I have tried google.

This is the error I get

Warning: ociparse() [function.ociparse]: ORA-01756: quoted string not properly terminated in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\qmon\age.php on line 46

Any idea,thanks in advance.

[debasisdas]

to enter single quotes you need to enter 2 single quotes ('') also do not forget to enclose those by enclosing single quotes.

[keerthanasunder]

insert into test values('Raju'||''''||'s Pen');

inside the single quotes two single quotes will be added then it will be concatenated with the string