您可以使用递归子查询因式分解子句递归每个数字的数字，并对数字的立方求和以查找匹配的数字：

WITH rsqfc ( value, pos, total ) AS (
  SELECT value,
         1,
         POWER(SUBSTR(value, 1, 1), LENGTH(value))
  FROM   table_name
  WHERE  POWER(SUBSTR(value, 1, 1), LENGTH(value)) <= value
UNION ALL
  SELECT value,
         pos + 1,
         total + POWER(SUBSTR(value, pos + 1, 1), LENGTH(value))
  FROM   rsqfc
  WHERE  pos < LENGTH(value)
  AND    total + POWER(SUBSTR(value, pos + 1, 1), LENGTH(value)) <= value
)
SEARCH DEPTH FIRST BY value SET order_id
SELECT value
FROM   rsqfc
WHERE  pos = LENGTH(value)
AND    total = value;

其中，对于样本数据：

CREATE TABLE table_name (value) AS
SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 400;

输出：
| 值|
| --|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 153 |
| 370 |
| 371 |
fiddle