| Sqlloader - Removing Spl. Characters( ' " ,) [message #69483] |
Fri, 18 January 2002 05:39  |
Raj Jayaraman
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
While loading thru sql*loader, I have to update the spl. characters present in the Data with spaces
' (Single quotes)
" (Double quotes)
, (comma)
I tried the following in the sqlplus and it worked there.
Select TRANSLATE('H''E"LL,O','''",',' ') from dual;
But when I use it sql*loader it is coming out with error. I used
Description "TRANSLATE(:DESCRIPTION,'''",',' ')"
it is coming out with the following error.
Expected Double quotes, found single quotes.
Can someone help with this.
- Raj
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
