Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t( col VARCHAR(100) )
INSERT INTO t VALUES('united   '||CHR(9)||'states  of america'||CHR(13))
  
1 rows affected

SELECT col AS col1, 
       LENGTH(col) AS len_col1,
       REPLACE(col,' ') AS col2,
       LENGTH(REPLACE(col,' ')) AS len_col2,
       REGEXP_REPLACE(col,'[[:space:]]') AS col3,
       LENGTH(REGEXP_REPLACE(col,'[[:space:]]')) AS len_col3,
       SUBSTR( REGEXP_REPLACE(col,'[[:space:]]'), 1, 8) AS "Result"
  FROM t
  


COL1
LEN_COL1
COL2
LEN_COL2
COL3
LEN_COL3
Result


united    states  of america

29
united statesofamerica

23
unitedstatesofamerica
21
unitedst