Trim TAB/CR/LF/Space from string


/ Published in: PL/SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. SELECT REGEXP_REPLACE(
  2. 'string'
  3. , '^([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+|([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+$', '*') AS result
  4. FROM dual;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.