Home » RDBMS Server » Server Administration » inverted commas in data
inverted commas in data [message #373361] Thu, 12 April 2001 11:43 Go to next message
Gareth
Messages: 2
Registered: April 2001
Junior Member
Good Morning

I'm trying to insert data into a varchar2 field, that may contain an inverted comma (week's). In the documentation, it tells me to escape an inverted comma with two (week's > week''s). I tried this, but instead of recording just one, it records two (week''s). My question is: how do I escape inverted commas, so that the resulting data field contains only 1 inverted comma.

Thanks

Gareth Cornish

Report message to a moderator

Re: inverted commas in data [message #373365 is a reply to message #373361] Thu, 12 April 2001 13:43 Go to previous message
Krishnan
Messages: 18
Registered: October 2000
Junior Member
insert into table1 (col1) values 'week''s'

Report message to a moderator

Previous Topic: hi
Next Topic: ORA-01031 when create a MV
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 09:50:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.