oracle加自然数,求教：如何在数据库中取得小于某个数的所有自然数？

再丢一次人吧，把全部SQL贴出来，请高手指点一下：

SELECT DISTINCT

A.ITEM102,

A.ITEM103,

B.ITEM104,

B.ITEM105

FROM

(SELECT DISTINCT

A.PRESS_JUN                                          AS  ITEM102,

''                                                          AS  ITEM103,

B.ITEM104                     AS  ITEM104,

B.ITEM105                     AS  ITEM105

FROM

KEI_COM_FU001 A,

(SELECT DISTINCT

A.ITEM104 AS ITEM104,

B.ITEM105 AS ITEM105

FROM

(SELECT DISTINCT

A.ITEM104 AS ITEM104

FROM

(

SELECT DISTINCT

ROWNUM AS ITEM104

FROM

all_objects

)A,

(

SELECT DISTINCT

MAX(END_DANSU) AS ITEM104

FROM

KEI_COM_FU001

)B

WHERE (1=1)

AND A.ITEM104<=B.ITEM104

)A,

(

SELECT DISTINCT

A.ITEM105 AS ITEM105

FROM

(

SELECT DISTINCT

ROWNUM AS ITEM105

FROM

all_objects

)A,

(

SELECT DISTINCT

MAX(END_MAISU) AS ITEM105

FROM

KEI_COM_FU001

)B

WHERE (1=1)

AND A.ITEM105<=B.ITEM105

)B

)B

WHERE (1=1)

AND (A.PRESS_SKBN        = 'P58260104')

AND (A.END_DANSU        =B.ITEM104)

AND (A.END_MAISU        =B.ITEM105        )

)A,

(SELECT DISTINCT

A.ITEM104 AS ITEM104,

B.ITEM105 AS ITEM105

FROM

(SELECT DISTINCT

A.ITEM104 AS ITEM104

FROM

(

SELECT DISTINCT

ROWNUM AS ITEM104

FROM

all_objects

)A,

(

SELECT DISTINCT

MAX(END_DANSU) AS ITEM104

FROM

KEI_COM_FU001

)B

WHERE (1=1)

AND A.ITEM104<=B.ITEM104

)A,

(

SELECT DISTINCT

A.ITEM105 AS ITEM105

FROM

(

SELECT DISTINCT

ROWNUM AS ITEM105

FROM

all_objects

)A,

(

SELECT DISTINCT

MAX(END_MAISU) AS ITEM105

FROM

KEI_COM_FU001

)B

WHERE (1=1)

AND A.ITEM105<=B.ITEM105

)B

)B

WHERE

A.ITEM104(+)=B.ITEM104

AND A.ITEM105(+)=B.ITEM105

ORDER BY

ITEM104 DESC