Home » SQL & PL/SQL » SQL & PL/SQL » single quote
single quote [message #36056] Thu, 01 November 2001 11:18 Go to next message
Kane
Messages: 15
Registered: November 2001
Junior Member
hi.

how do you insert a string with a single quote into a table. I know u can use 2 single quotes, but how do you convert the string with one single quote to one with 2 single quotes?

kane

----------------------------------------------------------------------
Re: single quote [message #36057 is a reply to message #36056] Thu, 01 November 2001 11:30 Go to previous message
pb
Messages: 18
Registered: December 2000
Junior Member
Modify your solution using the example below.

The following statement will display o'reily as o''reily

select replace('o''reily','''','''''')
from dual;

----------------------------------------------------------------------
Previous Topic: Insert Multiple values on an If statement
Next Topic: sql join question
Goto Forum:
  


Current Time: Mon Oct 26 14:52:04 CDT 2020