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

Report message to a moderator

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

Report message to a moderator

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....

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:36:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.