INSERT INTO EXTRA_POINT (
    NM, DT, ADD_POINT, BASE
)
WITH BASE_POINT AS (
    SELECT 300 BASE,  100 ADD_POINT FROM DUAL
    UNION ALL SELECT 500 BASE,  100 ADD_POINT FROM DUAL
    UNION ALL SELECT 750 BASE,  200 ADD_POINT FROM DUAL
    UNION ALL SELECT 1000 BASE,  300 ADD_POINT FROM DUAL
    UNION ALL SELECT 1000 + ROWNUM*500, 500 FROM DUAL CONNECT BY LEVEL <= 10  -- 적당히
),
TABLE_POINT AS (
    SELECT 'TOM' NM,  600 POINT FROM DUAL
    UNION ALL SELECT 'JOHN' NM,  1300 POINT FROM DUAL
)
SELECT
    A.NM, SYSDATE, T.ADD_POINT, T.BASE
FROM (
    SELECT NM, SUM(POINT) POINT_SUM
    FROM TABLE_POINT
    GROUP BY NM
    HAVING SUM(POINT) >= 300
) A, BASE_POINT T
WHERE T.BASE <= POINT_SUM
AND NOT EXISTS (
        SELECT 'X' FROM EXTRA_POINT E
        WHERE E.NM=A.NM
        AND E.BASE = T.BASE
    )

 도와주셔서 감사드려요...이제 좀 앞이 보이네요...

나중에 수정을 하긴 했는데 못보셨나보네요..

UNION ALL SELECT 1000 + ROWNUM*500 BASE, 500 ADD_POINT FROM DUAL

CONNECT BY LEVEL <= 10 -- 적당히

헤매고 있었는데...

감사드립니다. 

많은 도움 주셔서 감사드려요