Home » RDBMS Server » Server Utilities » Sqlloader - Removing Spl. Characters( ' " ,)
Sqlloader - Removing Spl. Characters( ' " ,) [message #69483] Fri, 18 January 2002 05:39 Go to next message
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
Re: Sqlloader - Removing Spl. Characters( ' " ,) [message #69489 is a reply to message #69483] Sat, 19 January 2002 09:51 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Description "replace(replace(replace(:Description,chr(39),'' ),chr(34),''),chr(44),'')"

Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Sat Mar 02 14:52:01 CST 2024