Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01756: quoted string not properly terminated
ORA-01756: quoted string not properly terminated [message #194742] Mon, 25 September 2006 01:15 Go to next message
rajuakula
Messages: 63
Registered: March 2005
Member
I have table1

id
description

insert into table1(id,description) values
(1,'xyz's and abc's');

getting the following error

ORA-01756: quoted string not properly terminated

thanks
Re: ORA-01756: quoted string not properly terminated [message #194743 is a reply to message #194742] Mon, 25 September 2006 01:19 Go to previous message
Liza79
Messages: 74
Registered: September 2006
Member
rajuakula wrote on Mon, 25 September 2006 01:15

insert into table1(id,description) values
(1,'xyz's and abc's');


Try this

insert into table1(id,description) values
(1,'xyz''s and abc''s');

its not a double quotation mark, its the single quotation mark two times. Smile

Liza

[Updated on: Mon, 25 September 2006 01:20]

Report message to a moderator

Previous Topic: How to Grant CONNECT only privleges to user?
Next Topic: Global variable
Goto Forum:
  


Current Time: Mon Dec 05 02:33:23 CST 2016

Total time taken to generate the page: 0.18582 seconds