Home » RDBMS Server » Networking and Gateways » INSERT with single quote
INSERT with single quote [message #66305] Wed, 20 March 2002 14:47 Go to next message
Humberto
Messages: 1
Registered: March 2002
Junior Member
Hi,

I need to insert some alphanumeric values into a table but some of them have a single quote as part of the data. I do not know how to write an SQL sentence to do it due to the string should be enclosed between single quotes.

I am using ORACLE.

Regards,
HA
Re: INSERT with single quote [message #66355 is a reply to message #66305] Wed, 24 April 2002 20:17 Go to previous messageGo to next message
srinivasarao
Messages: 15
Registered: April 2002
Junior Member
hai
while inserting single quotes
add one more single quote to that like
insert into emp(ename)values('yours''faithfully')
to insert the yours'faithfully

all the best
srinivasarao.pamidi
Re: INSERT with single quote [message #66658 is a reply to message #66355] Sun, 06 October 2002 22:06 Go to previous messageGo to next message
imran rauf
Messages: 1
Registered: October 2002
Junior Member
just check it, it does'nt work....
Re: INSERT with single quote [message #66681 is a reply to message #66658] Mon, 14 October 2002 15:32 Go to previous message
Tom Gropel
Messages: 1
Registered: October 2002
Junior Member
Try using two single quotes back-to-back, not the actually double quote value. It should work.

Tom
Previous Topic: SQL* Net V2 Listener Error
Next Topic: TNS protocol adapter error on windows 98
Goto Forum:
  


Current Time: Wed Feb 28 02:54:25 CST 2024