|
WITH t(str) AS (
SELECT CAST(LEVEL AS VARCHAR2(10)) FROM DUAL CONNECT BY LEVEL<10
UNION ALL
SELECT str||n2
FROM t
,(SELECT LEVEL-1 n2 FROM DUAL CONNECT BY LEVEL<=10)
WHERE INSTR(str,n2)=0
AND (LENGTH(str)<3
OR
LENGTH(str)>=3 AND SUBSTR(str,-1,1)*SUBSTR(str,-2,1)>SUBSTR(str,-1,1)+SUBSTR(str,-2,1)+SUBSTR(str,-3,1)+n2
)
)
SELECT MAX(TO_NUMBER(str)) FROM t;
MAX(TO_NUMBER(STR))
-------------------
1956483720
再给猫发个章。 |
|