Oracle-judge whether a number is prime ____oracle

The method of judging the prime number, starting from 2, all except itself and 1, can not be divisible, is the prime number.

Createor REPLACE

FUNCTION IsPrime (

Num in number)

Return BOOLEAN

Is

BEGIN

IF (num<=1) THEN

return FALSE;

End IF;

For I in 2. (num-1)

LOOP

IF (mod (num,i) =0) THEN

return FALSE;

End IF;

End LOOP;

return TRUE;

End;

Call this function

Declare

Aboolean;

Begin

A: =isprime (27);

If a then

Dbms_output.put_line (' prime number ');

Else

Dbms_output.put_line (' Non prime number ');

End If;

End

Return Result: false

Explanation: Cannot direct selectisprime from dual Oracle does not have a Boolean data type, but there are some in PLQSL, so LS has a problem, and in function write no problem