Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT REGEXP_REPLACE('QUADRA317 LOTE 19 CASA 01 ', '( ){2,}', ' ') FROM DUAL;
- SELECT regexp_replace('This string contains more than one spacing between the words','( ){2,}',' ') regexp_replace FROM dual;
- --http://www.dba-oracle.com/t_regexp_replace.htm
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement