Home » RDBMS Server » Server Administration » Re: single quote
Re: single quote [message #373782] Tue, 08 May 2001 08:04 Go to next message
siddharth
Messages: 16
Registered: May 2001
Junior Member
Just replace each ' with '' (Single quote two times)

Report message to a moderator

Re: single quote [message #373786 is a reply to message #373782] Tue, 08 May 2001 12:58 Go to previous message
Sundar Venkatasubramaniam
Messages: 26
Registered: May 2001
Junior Member
Assume that table is t1 with column c1 and your want to insert 'abc' . then you can try like this

insert into t1(c1) values(chr(39)||'abc'||chr(39))

Note this method will be useful for inserting strings with mulitiple quoted strings inside like 'abc'ef'gh'.

Report message to a moderator

Previous Topic: Cannot log in the DB through TOAD
Next Topic: decode function(urgent)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:35:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.