Advertisement
NightRaven97

rev of num

Sep 8th, 2016
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.26 KB | None | 0 0
  1. DECLARE
  2. num NUMBER;
  3. rev NUMBER:=0;
  4. rem NUMBER;
  5. copy NUMBER;
  6.  
  7. BEGIN
  8. num:=#
  9. copy:=num;
  10. WHILE num>0
  11. LOOP
  12.     rev:=rev*10;
  13.     rem:=MOD(num,10);
  14.     rev:=rev+rem;
  15.     num:=TRUNC(num/10);
  16. END LOOP;
  17. DBMS_OUTPUT.put_line('Reverse of '|| copy || ' is ' || rev);
  18. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement