SQL> with data as (
  2  select '411-123 TEST' val from dual union all
  3  select '1-151 ANOTHER TEST' val from dual union all
  4  select '1151-1 ONE MORE TEST' val from dual union all
  5  select '1151-147LAST TEST' val from dual union all
  6  select 'SPECIAL TEST' val from dual
  7  )
  8  select val, regexp_instr(val,'[^0-9-]') ind from data;
VAL                         IND
-------------------- ----------
411-123 TEST                  8
1-151 ANOTHER TEST            6
1151-1 ONE MORE TEST          7
1151-147LAST TEST             9
SPECIAL TEST                  1

WITH D AS 
(SELECT '1234-32 1A' STR FROM DUAL UNION ALL
 SELECT '1234-32 ABC' STR FROM DUAL UNION ALL
 SELECT 'SS1234-32 1A' STR FROM DUAL)
SELECT STR,REGEXP_INSTR(STR,'[^ 0-9-]') OUTPUT
FROM D;

STR                   OUTPUT
------------ ----------
1234-32 1A           10 
1234-32 ABC           9 
SS1234-32 1A          1 

WITH D AS 
(SELECT '1234-32 1A' STR FROM DUAL UNION ALL
 SELECT '1234-32 ABC' STR FROM DUAL UNION ALL
 SELECT 'SS1234-32 1A' STR FROM DUAL)
SELECT STR,REGEXP_INSTR(STR,'[[:alpha:]]') OUTPUT
FROM D
/

STR              OUTPUT
------------ ----------
1234-32 1A           10
1234-32 ABC           9
SS1234-32 1A          1

SCOTT@pdb1orcl12 >

REGEXP_INSTR(STR,'[[:alpha:]]')