| single quote [message #36056] |
Thu, 01 November 2001 11:18  |
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  |
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;
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
