Advertisement
Guest User

Untitled

a guest
Oct 25th, 2014
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.83 KB | None | 0 0
  1. DECLARE
  2.     nama VARCHAR2(40) := '&NAMA';
  3.     i NUMBER := 1;
  4.     panjang NUMBER := LENGTH(nama);
  5.     j NUMBER := i;
  6. BEGIN
  7.     WHILE i <= panjang LOOP
  8.         WHILE j <= i LOOP
  9.             DBMS_OUTPUT.put(' ');
  10.             j := j + 1;
  11.         END LOOP;
  12.         j := 1;
  13.         DBMS_OUTPUT.put_line(SUBSTR(nama, i, 1));
  14.         i := i + 1;
  15.     END LOOP;
  16. END;
  17. /
  18.  
  19. DECLARE
  20.     angka NUMBER := '&Angka';
  21.     i NUMBER := TRUNC(angka/5) + 1;
  22.     p NUMBER := 64;
  23.     a NUMBER := 1;
  24.     j NUMBER;
  25. BEGIN
  26.     WHILE a < i LOOP
  27.         IF MOD(a,2) = 1 THEN
  28.             FOR j IN 1..5 LOOP
  29.                 p := p + 1;
  30.                 DBMS_OUTPUT.put( CHR(p) || ' ');
  31.             END LOOP;
  32.             DBMS_OUTPUT.new_line;
  33.         ELSE
  34.             p := p + 5;
  35.             j := 1;
  36.             WHILE j <= 5 LOOP
  37.                 DBMS_OUTPUT.put( CHR(p) || ' ');
  38.                 p := p - 1;
  39.                 j := j + 1;
  40.             END LOOP;
  41.             p := p + 5;
  42.             DBMS_OUTPUT.new_line;
  43.         END IF;
  44.         a := a + 1;
  45.     END LOOP;
  46.     DBMS_OUTPUT.new_line;
  47. END;
  48. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement