Home » SQL & PL/SQL » SQL & PL/SQL » Remove Special chracters and Carriage
Remove Special chracters and Carriage [message #403218] Thu, 14 May 2009 05:29 Go to next message
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
Hi Group,

I would like to get a query to remove all the special characters like {}?><| etc and chr(13),chr(10),

Responses appreciated.

Regards,
Abbas.
Re: Remove Special chracters and Carriage [message #403222 is a reply to message #403218] Thu, 14 May 2009 05:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
REPLACE them with nothing (NULL).
Re: Remove Special chracters and Carriage [message #403224 is a reply to message #403218] Thu, 14 May 2009 05:50 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could also consider REGEXP_REPLACE if you are on 10g or above.
Previous Topic: Running procedure in background on button click
Next Topic: Package verification
Goto Forum:
  


Current Time: Sat Dec 10 08:52:20 CST 2016

Total time taken to generate the page: 0.09651 seconds