Oracle extract alpha characters from string

Question

I want to extract only alpha characters separately.
For example Output for "NIC132DA.1" should be "NIC" and "DA" separately without any numbers.
I tried following query:

select regexp_replace('NIC132DA.1','[^A-Za-z]') from dual;

I get following output: NICDA
Expected out put is "NIC" and "DA" separately.
Note: Number of alpha characters are not fixed in input string.

Answer 1

You can use REGEXP_SUBSTR:

select 
    regexp_substr('NIC132DA.1','[A-Za-z]+', 1, 1) first,
    regexp_substr('NIC132DA.1','[A-Za-z]+', 1, 2) second
from dual;

It's better to use multilingual character class [:alpha:]:

select 
    regexp_substr('NIC132DA.1','[[:alpha:]]+', 1, 1) first,
    regexp_substr('NIC132DA.1','[[:alpha:]]+', 1, 2) second
from dual;