Oracle Replace Function:
REGEXP_REPLACE(,'[^[:alnum:]'' '']', NULL)
Example:
SELECT
REGEXP_REPLACE('##$$$Franesco Paganelli ALèE''&&!!__!','[^[:alnum:]'' '']', NULL)
FROM dual;
--Output
Franesco Paganelli ALèE'
REGEXP_REPLACE(
Example:
SELECT
REGEXP_REPLACE('##$$$Franesco Paganelli ALèE''&&!!__!','[^[:alnum:]'' '']', NULL)
FROM dual;
--Output
Franesco Paganelli ALèE'
Nessun commento:
Posta un commento