CREATE TABLE lltable_01(col1 VARCHAR2(20));INSERT INTO lltable_01 VALUES('111222333000'); INSERT INTO lltable_01 VALUES('444555666000');SELECT * FROM lltable_01UPDATE lltable_01 SET col1=SUBSTR(col1,0,3)||SUBSTR(col1,10,3)||SUBSTR(col1,7,3)||SUBSTR(col1,4,3)SELECT col1,SUBSTR(col1,0,3),SUBSTR(col1,4,3),SUBSTR(col1,7,3),SUBSTR(col1,10,3) FROM lltable_01DROP TABLE lltable_01--我这么做好像太复杂了
VALUES('111222333000');
INSERT INTO lltable_01
VALUES('444555666000');SELECT * FROM lltable_01UPDATE lltable_01 SET col1=SUBSTR(col1,0,3)||SUBSTR(col1,10,3)||SUBSTR(col1,7,3)||SUBSTR(col1,4,3)SELECT col1,SUBSTR(col1,0,3),SUBSTR(col1,4,3),SUBSTR(col1,7,3),SUBSTR(col1,10,3)
FROM lltable_01DROP TABLE lltable_01--我这么做好像太复杂了
不知道是否有简单一点的