Replace Alphabets in the String in Oracle SQL

to_number(REGEXP_REPLACE(REGEXP_REPLACE(p_string,'[[:alpha:]]'),'[.]'))

select to_number(REGEXP_REPLACE(REGEXP_REPLACE('AA.09A','[[:alpha:]]'),'[.]')) from dual

Output:

---------------------------

9