| Insert Data with an apostrophe [message #168681] |
Fri, 21 April 2006 10:58  |
vvelu
Messages: 1
Registered: April 2006
|
Junior Member |
|
|
Have a select statement that fetches data into variables from a table.
Have a dynamic insert that uses these variables as values to insert a table via dB link.
Problem I am facing is that some of these data have an apostrophe in them, for eg: addres line 1, has "SHANK's Corner"
My dynamic insert aborts because of this data.
Is there a function in Oracle (8i) that can eliminate such special characters and return just plain alphabets, that anyone knows of?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
