Advertisement
Guest User

Untitled

a guest
Feb 27th, 2020
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. SET SERVEROUTPUT ON
  2.  
  3. --DECLARE
  4. -- n NUMBER := 127;-- n Number := &n;
  5. --
  6. --BEGIN
  7. -- IF n mod 2 = 0
  8. -- THEN
  9. -- DBMS_OUTPUT.PUT_LINE('The number ' || TO_CHAR(n) || ' is even.');
  10. -- ELSE
  11. -- DBMS_OUTPUT.PUT_LINE('The number ' || TO_CHAR(n) || ' is odd.');
  12. -- END IF;
  13. --END;
  14. --/
  15.  
  16. --declare
  17. -- n1 NUMBER :=120;
  18. -- n2 NUMBER :=500;
  19. -- n3 NUMBER :=400;
  20. --begin
  21. -- if (n1 > n2 and n1 > n3)
  22. -- then
  23. -- DBMS_OUTPUT.PUT_LINE('The number ' || TO_CHAR(n1) || ' is the greatest one.');
  24. -- elsif (n2 > n1 and n2 > n3)
  25. -- then
  26. -- DBMS_OUTPUT.PUT_LINE('The number ' || TO_CHAR(n2) || ' is the greatest one.');
  27. -- else
  28. -- DBMS_OUTPUT.PUT_LINE('The number ' || TO_CHAR(n3) || ' is the greatest one.');
  29. -- end if;
  30. --end;
  31. --/
  32.  
  33. --declare
  34. --n NUMBER := 2000;
  35. -- n NUMBER := &n;
  36. --begin
  37. -- if (n mod 4) = 0 and (n mod 100) != 0 or (n mod 400) = 0
  38. -- then
  39. -- DBMS_OUTPUT.PUT_LINE('the date ' || TO_CHAR(n) || ' nagyon szökik.');
  40. -- else
  41. -- DBMS_OUTPUT.PUT_LINE('the date ' || TO_CHAR(n) || ' nagyon nem szökik.');
  42. -- END IF;
  43. --END;
  44. --/
  45. --osztható 4gyel nem osztható százzal vagy osztható 400zal, akkor szökőév
  46.  
  47. --declare
  48. -- n0 number :=0;
  49. -- n1 number :=1;
  50. -- n number := &n;
  51. -- n2 number :=n1+n0;
  52. --begin
  53. -- for i in 0..n
  54. -- loop
  55. -- n2 := n0+n1;
  56. -- n0 := n1;
  57. -- n1 := n2;
  58. -- DBMS_OUTPUT.PUT_LINE('the number ' || TO_CHAR(n2) || ' asdad.');
  59. -- end loop;
  60. --end;
  61.  
  62. declare
  63. n number := &n;
  64. van number :=0;
  65.  
  66. begin
  67. for i in 2..sqrt(n)
  68. loop
  69. if (n mod i) = 0
  70. then
  71. van := van + 1;
  72. end if;
  73. end loop;
  74. if van > 0 then
  75. DBMS_OUTPUT.PUT_LINE('the number ' || TO_CHAR(n) || ' nem prim.');
  76. else
  77. DBMS_OUTPUT.PUT_LINE('the number ' || TO_CHAR(n) || ' prim.');
  78. end if;
  79. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement