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.
to enter single quotes you need to enter 2 single quotes ('') also do not forget to enclose those by enclosing single quotes.
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.