Untuk mengeluarkan nilai berupa number di query :
select regexp_replace('12345TTdfjsakjfdaTT', '[A-Za-z]') satu,
regexp_replace('12345TTT8799Tdasf!', '[^[:digit:]]') dua,
REGEXP_REPLACE('max1a23b56','[[:alpha:]]') tiga
from dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','\D') FROM dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','[^0-9]') FROM dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','[^[:digit:]]') FROM dual;
Link referensi :
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm
select regexp_replace('12345TTdfjsakjfdaTT', '[A-Za-z]') satu,
regexp_replace('12345TTT8799Tdasf!', '[^[:digit:]]') dua,
REGEXP_REPLACE('max1a23b56','[[:alpha:]]') tiga
from dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','\D') FROM dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','[^0-9]') FROM dual;
SELECT regexp_replace('12ZXC3ASD456FGH8TED63','[^[:digit:]]') FROM dual;
Link referensi :
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm