將字符和數字數據分離

將字符和數字數據分離

創建測試用表：   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;   執行結果如下：