CREATE TABLE BOLTS ( BS_CODE VARCHAR2(12),BS_DESC VARCHAR2(30));

INSERT INTO BOLTS(BS_CODE,BS_DESC) VALUES ('1','BOLTS_1NUTS_1WASHERS');

INSERT INTO BOLTS(BS_CODE,BS_DESC) VALUES ('2','BOLTS_2NUTS_1WASHERS');

INSERT INTO BOLTS(BS_CODE,BS_DESC) VALUES ('3','BOLTS_1NUTS_2WASHERS');


SELECT bs_desc,
       SUBSTR (bs_desc,
               REGEXP_INSTR (bs_desc, '(\d)', 1, 1, 0),
               1
              ) first_reference,
       SUBSTR (bs_desc,
               REGEXP_INSTR (bs_desc, '(\d)', 8, 1, 0),
               1
              ) second_number
  FROM bolts;


FIRST_REFERENCE,SECOND_NUMBER
1,1
2,1
1,2

SQL> select bs_desc, regexp_substr(bs_desc,'(\d)') first,
  2         regexp_substr(bs_desc,'(\d)',1,2) second
  3  from BOLTS
  4  /
BS_DESC                        FIRST                          SECOND
------------------------------ ------------------------------ ------------------------------
BOLTS_1NUTS_1WASHERS           1                              1
BOLTS_2NUTS_1WASHERS           2                              1
BOLTS_1NUTS_2WASHERS           1                              2