Home » SQL & PL/SQL » SQL & PL/SQL » how to remove special character and albhabet in the given string (oracle 10g)
how to remove special character and albhabet in the given string [message #442270] Sat, 06 February 2010 05:42 Go to next message
chaituu
Messages: 115
Registered: June 2008
Senior Member
how to remove /R in the given strings.

abccc00121837/R=abccc00121837
adad00091/R=adad00091
ad00091/R=ad00091
Re: how to remove special character and albhabet in the given string [message #442274 is a reply to message #442270] Sat, 06 February 2010 06:59 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
REPLACE(my_string, '/R', NULL)


Ross Leishman
Re: how to remove special character and albhabet in the given string [message #442276 is a reply to message #442274] Sat, 06 February 2010 07:27 Go to previous messageGo to next message
navin_deep
Messages: 18
Registered: November 2009
Junior Member
Hi
suppose i have strin 'ashfeugh$56/S2&*' and i want to remove multiple special characters ($,S,&,*), then what will be the function to use here ?

-navin
Re: how to remove special character and albhabet in the given string [message #442285 is a reply to message #442276] Sat, 06 February 2010 09:02 Go to previous message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TRANSLATE

Same answer than to the same question 2 days ago in topic:
http://www.orafaq.com/forum/mv/msg/154747/442071/102589/#msg_442071

Is there an exam going on?

Regards
Michel

[Updated on: Sat, 06 February 2010 09:02]

Report message to a moderator

Previous Topic: Procedure Calls
Next Topic: Table design
Goto Forum:
  


Current Time: Sat Oct 01 17:51:36 CDT 2016

Total time taken to generate the page: 0.08588 seconds