SPECIAL CHARACTER IS TO REMOVE FROM THE TABLE IN ORACLE APPS
1, select regexp_replace('This is a test $%&^*&*'||chr(10)||'*"ú%bsf-d.', '( *[[:punct:]])', '') from dual
2, select regexp_replace(descriptions, '( *[[:punct:]])', '') from apps.mtl_system_items_b
1, select regexp_replace('This is a test $%&^*&*'||chr(10)||'*"ú%bsf-d.', '( *[[:punct:]])', '') from dual
2, select regexp_replace(descriptions, '( *[[:punct:]])', '') from apps.mtl_system_items_b
No comments:
Post a Comment