Menggunakan REGEXP_REPLACE

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