WITH CIF AS (SELECT '2477882_COLL_1' AS VAL FROM DUAL UNION ALL
SELECT '2794409_COLL_1' FROM DUAL
UNION ALL
SELECT '2291_Coll_1' FROM DUAL
UNION ALL
SELECT '2291' FROM DUAL)
SELECT * FROM CIF WHERE 
VAL = CASE WHEN VAL LIKE '%\_1%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_2%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_3%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_4%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_5%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_6%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_7%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_8%' ESCAPE '\' THEN VAL
WHEN VAL LIKE '%\_9%' ESCAPE '\' THEN VAL
END 

SQL> WITH CIF AS
  2    (SELECT '2477882_COLL_1' AS VAL FROM DUAL
  3    UNION ALL
  4    SELECT '2794409_COLL_1' FROM DUAL
  5    UNION ALL
  6    SELECT '2291_Coll_1' FROM DUAL
  7    UNION ALL
  8    SELECT '2291' FROM DUAL
  9    UNION ALL
 10    SELECT '2291_a' FROM DUAL
 11    UNION ALL
 12    SELECT '2291_1_a' FROM DUAL
 13    )
 14  SELECT * FROM CIF
 15  WHERE REGEXP_LIKE(VAL,'_[[:digit:]]')
 16  /

VAL
--------------
2477882_COLL_1
2794409_COLL_1
2291_Coll_1
2291_1_a