You can use the REPLACE function to replace the special characters.
Example:
SELECT 'OR%^$&*AC&^LE' original_string
,REPLACE (
REPLACE (
REPLACE (
REPLACE (
REPLACE (REPLACE ('OR%^$&*AC&^LE', '%', NULL)
,'^'
,NULL)
,'&'
,NULL
)
,'$'
,NULL
)
,'%'
,NULL
)
,'*'
,NULL
)
modified_string
FROM DUAL
Put that in a function or in a general package and ready.
On Mon, Nov 30, 2009 at 4:22 AM, Niraj Singh The King <
[email protected]> wrote:
> Please help me in providing a sample code to remove special characters from
> a string
>
> For E.g if i give string "OR%^$&*AC&^LE" the o/p should be "ORACLE"
> --
> Thanks and Regards,
> Niraj Singh Parihar
> Mobile Number : +919890492566.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
--
Patricio Rodriguez
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
