We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
In ORacle :
SELECT LISTAGG(L1,'&') WITHIN GROUP (ORDER BY L1) FROM (Select L1 FROM (SELECT LEVEL L1 FROM DUAL CONNECT BY LEVEL<=1000) Where L1 <> 1
MINUS
select L1 from
(SELECT LEVEL L1 FROM DUAL CONNECT BY LEVEL<=1000) A ,
(SELECT LEVEL L2 FROM DUAL CONNECT BY LEVEL<=1000) B
Where L2<=L1 and MOD(L1,L2)=0 AND L1<>L2 AND L2<>1);
Print Prime Numbers
You are viewing a single comment's thread. Return to all comments →
In ORacle : SELECT LISTAGG(L1,'&') WITHIN GROUP (ORDER BY L1) FROM (Select L1 FROM (SELECT LEVEL L1 FROM DUAL CONNECT BY LEVEL<=1000) Where L1 <> 1 MINUS select L1 from (SELECT LEVEL L1 FROM DUAL CONNECT BY LEVEL<=1000) A , (SELECT LEVEL L2 FROM DUAL CONNECT BY LEVEL<=1000) B Where L2<=L1 and MOD(L1,L2)=0 AND L1<>L2 AND L2<>1);