感谢不尽, 在线等
Define a table primes that has a single column containing all prime numbers up to 100.create table primes as
select
Here's what your output should look like.-- Example:
select * from primes;
-- Expected output:
-- 2
-- 3
-- 5
-- 7
-- 11
-- 13
-- 17
-- 19
-- 23
-- 29
-- 31
-- 37
-- 41
-- 43
-- 47
-- 53
-- 59
-- 61
-- 67
-- 71
-- 73
-- 79
-- 83
-- 89
-- 97
(SELECT ROWNUM + 1 RN
FROM DUAL
CONNECT BY ROWNUM <= 100 - 1)
SELECT *
FROM (SELECT RN
FROM T
MINUS
SELECT T1.RN * T2.RN
FROM T T1, T T2
WHERE T1.RN <= T2.RN
AND T1.RN <= (SELECT SQRT(100)
FROM DUAL))