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.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Print Prime Numbers
  5. Discussions

Print Prime Numbers

  • ljvmg11
     + 0 comments

    Oracle pl/sql

    SET SERVEROUTPUT ON;
DECLARE
RESULT VARCHAR2(2001) := '';
PRIM BOOLEAN := TRUE;

BEGIN
    FOR I IN 2.. 1000 LOOP    
        PRIM := TRUE;
        FOR J IN 2..FLOOR(sqrt(I)) LOOP
            if mod(i, j) = 0 then   
                PRIM := FALSE;
                EXIT;
            end if;
        END LOOP;
        
        IF PRIM THEN
            RESULT := RESULT || I || '&' ;
        END IF;
    END LOOP;
    DBMS_OUTPUT.PUT_LINE(substr(RESULT,1,length(RESULT)-1));
END;
/