Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Removing special characters from list

RengudiDec 1 2022 — edited Dec 1 2022

Hi
Best time,
I want remove all special to no space ''

CREATE VIEW spc_table(Special,characters) AS
SELECT '-¿---' AS Special,NULL AS characters FROM dual
UNION ALL
SELECT '-/',NULL FROM dual
UNION ALL
SELECT '--¿---------',NULL FROM dual
UNION ALL
SELECT '(¿)',NULL FROM dual
UNION ALL
SELECT '--¿--------',NULL FROM dual
UNION ALL
SELECT '-----¿-',NULL FROM dual
UNION ALL
SELECT '-----¿¿',NULL FROM dual
UNION ALL
SELECT '-(¿)',NULL FROM dual
UNION ALL
SELECT '-¿',NULL FROM dual
UNION ALL
SELECT '()(¿)',NULL FROM dual
UNION ALL
SELECT '---',NULL FROM dual
UNION ALL
SELECT '---',NULL FROM dual
UNION ALL
SELECT '-',NULL FROM dual
UNION ALL
SELECT '-----<-->-----',NULL FROM dual
UNION ALL
SELECT '--/--¿/',NULL FROM dual
UNION ALL
SELECT '-¿:----',NULL FROM dual
UNION ALL
SELECT '----',NULL FROM dual
UNION ALL
SELECT NULL,NULL FROM dual
UNION ALL
SELECT '--¿--------.',NULL FROM dual
UNION ALL
SELECT '¿',NULL FROM dual
UNION ALL
SELECT '-----<-->---',NULL FROM dual
UNION ALL
SELECT '---<¿>---',NULL FROM dual
UNION ALL
SELECT '---¿-..|¿',NULL FROM dual
UNION ALL
SELECT '--..¿--',NULL FROM dual
UNION ALL
SELECT '----<-->----',NULL FROM dual
UNION ALL
SELECT '---..¿--',NULL FROM dual
UNION ALL
SELECT '--¿----:',NULL FROM dual
UNION ALL
SELECT '¿--:',NULL FROM dual
UNION ALL
SELECT '(-)(¿)',NULL FROM dual
UNION ALL
SELECT '-,',NULL FROM dual
UNION ALL
SELECT '(¿)--!!!!!!',NULL FROM dual
UNION ALL
SELECT '--¿--',NULL FROM dual
UNION ALL
SELECT '-----',NULL FROM dual
UNION ALL
SELECT '/',NULL FROM dual
UNION ALL
SELECT '--:-:-',NULL FROM dual
UNION ALL
SELECT '------',NULL FROM dual
UNION ALL
SELECT '---',NULL FROM dual
UNION ALL
SELECT '-----<-->----',NULL FROM dual
UNION ALL
SELECT '----()',NULL FROM dual
UNION ALL
SELECT '-!!!!!!',NULL FROM dual
UNION ALL
SELECT '---<->¿-----',NULL FROM dual
UNION ALL
SELECT '¿¿-:',NULL FROM dual
UNION ALL
SELECT '----<-->---',NULL FROM dual
UNION ALL
SELECT '--',NULL FROM dual
UNION ALL
SELECT '----¿-',NULL FROM dual
UNION ALL
SELECT '---<-->--',NULL FROM dual
UNION ALL
SELECT '-¿()',NULL FROM dual
UNION ALL
SELECT '--¿',NULL FROM dual;

Possible?

Thanks
This post has been answered by User_63PY8 on Dec 2 2022
Jump to Answer
Comments
Post Details
Added on Dec 1 2022
4 comments
109 views