问当一个单词的最后一个字符是数字Oracle时提取

EN

WITH cteData AS (SELECT 'EXPA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'FTSA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'HUTS' AS TESTING FROM DUAL UNION ALL
                 SELECT 'JUF8' AS TESTING FROM DUAL UNION ALL
                 SELECT 'GTD9' AS TESTING FROM DUAL)
SELECT TESTING
  FROM cteData
  WHERE REGEXP_INSTR(TESTING, '[0-9]$') > 0;

WITH cteData AS (SELECT 'EXPA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'FTSA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'HUTS' AS TESTING FROM DUAL UNION ALL
                 SELECT 'JUF8' AS TESTING FROM DUAL UNION ALL
                 SELECT 'GTD9' AS TESTING FROM DUAL)
SELECT TESTING
  FROM cteData
  WHERE SUBSTR(TESTING, -1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9');

WITH cteData AS (SELECT 'EXPA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'FTSA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'HUTS' AS TESTING FROM DUAL UNION ALL
                 SELECT 'JUF8' AS TESTING FROM DUAL UNION ALL
                 SELECT 'GTD9' AS TESTING FROM DUAL)
SELECT TESTING
  FROM cteData
  WHERE INSTR('0123456789', SUBSTR(TESTING, -1)) > 0;

WITH cteData AS (SELECT 'EXPA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'FTSA' AS TESTING FROM DUAL UNION ALL
                 SELECT 'HUTS' AS TESTING FROM DUAL UNION ALL
                 SELECT 'JUF8' AS TESTING FROM DUAL UNION ALL
                 SELECT 'GTD9' AS TESTING FROM DUAL)
SELECT TESTING
  FROM cteData
  WHERE TRANSLATE(SUBSTR(TESTING, -1),
                  '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ',
                  '0123456789') IS NOT NULL;

select testing
from tablename
where regexp_like(testing, '[0-9]$')

WITH cteData AS (SELECT 'EXPA' AS TESTING FROM DUAL UNION ALL
             SELECT 'FTSA' FROM DUAL UNION ALL
             SELECT 'HUTS' FROM DUAL UNION ALL
             SELECT 'JUF8' FROM DUAL UNION ALL
             SELECT 'GTD9' FROM DUAL)
SELECT TESTING
  FROM cteData
  WHERE validate_conversion(substr(testing,-1) as integer) =1;