VIJAY SHARMA

• Sep 24th, 2012

Code
 
SELECT SEQNO "PRIME NUMBERS"
FROM(
     SELECT SEQNO
     FROM( 
          SELECT ROWNUM SEQNO
          FROM ALL_OBJECTS
          GROUP BY ROWNUM
          HAVING ROWNUM <= &GIVENNUM
         ),
         (
          SELECT ROWNUM SEQNO2
          FROM ALL_OBJECTS
          WHERE ROWNUM <= &GIVENNUM
         ) A2
    GROUP BY CUBE(SEQNO,SEQNO2)
    HAVING GROUPING_ID(SEQNO,SEQNO2) = 0 AND SEQNO >= SEQNO2 AND
    MOD(SEQNO,SEQNO2) = 0
    )
GROUP BY SEQNO
HAVING COUNT(*) IN(1,2)
ORDER BY SEQNO;

KARRTHIK

• Dec 3rd, 2011

"plsql n number; i number; counter number; begin n:=&n; i:=1; counter:=0; if n=1 then dbms_output.put_line('1 is a prime No.'); else if n=2 ...

Answer Question  Select Best Answer