But this will not be an generic code for all the special characters.Anyways
thanks
--
Thanks and Regards,
Opus Software Solution(Pune)
Niraj Singh Parihar
Mobile Number : +919890492566.
On Mon, Nov 30, 2009 at 7:34 PM, Patricio Rodriguez <
rodriguez.patri...@gmail.com> wrote:
> 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 <
> parihar.nirajsi...@gmail.com> 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 Oracle-PLSQL@googlegroups.com
>> To unsubscribe from this group, send email to
>> oracle-plsql-unsubscr...@googlegroups.com
>> 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 Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
