例如: SELECT REGEXP_REPLACE(COLUMN_NAME,'[0-9]','') AS STR1,REGEXP_REPLACE(COLUMN_NAME,'[^0-9]','') AS STR2 FROM TAB_NAME;