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

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?


Re: single quote [message #36057 is a reply to message #36056] Thu, 01 November 2001 11:30 Go to previous message
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: Tue May 28 05:17:12 CDT 2024