將字符和數字數據分離，字符和數分離

將字符和數字數據分離，字符和數分離

創建測試用表：

CREATE OR REPLACE VIEW v AS
SELECT 'A1' AS c FROM DUAL
UNION ALL
SELECT '12B' AS c FROM DUAL;
SELECT * FROM v;

SQL代碼如下：

SELECT REGEXP_REPLACE(c, '[0-9]', '') AS c1,
       REGEXP_REPLACE(c, '[^0-9]', '') AS c2
  FROM v;

執行結果如下：