具体如下:
SQL> select * from test_blank;
A
---------------------------------------
ed f fdfa dsf
bdf farer ds f
c df faer ered esf
ddf fae erfad dsf
h df y faf asdsf
j df fadf dsasf
kdf fadfasesf
a df faer erds f
fdf fad afssf
gdf faad fd sf
idf f adsfadf
11 rows selected
SQL>
SQL> select a,
2 lpad(' ', length(a) - length(ltrim(a)), ' ' ) || replace(a, ' ', '') || rpad(' ', length(a) - length(rtrim(a)), ' ' ) new_a --把中间的空格都去掉,两边的空格保留
3 from test_blank;
A NEW_A
--------------------------------------- --------------------------------------------------------------------------------
ed f fdfa dsf edffdfadsf
bdf farer ds f bdffarerdsf
c df faer ered esf cdffaereredesf
ddf fae erfad dsf ddffaeerfaddsf
h df y faf asdsf hdfyfafasdsf
j df fadf dsasf jdffadfdsasf
kdf fadfasesf kdffadfasesf
a df faer erds f adffaererdsf
fdf fad afssf fdffadafssf
gdf faad fd sf gdffaadfdsf
idf f adsfadf idffadsfadf
11 rows selected
SQL>