Advertisement
Aniket_Goku

REVERS SQL

Sep 12th, 2020
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.30 KB | None | 0 0
  1. /* REVERSE number*/
  2. DECLARE
  3.     ans VARCHAR(30);
  4.  
  5.     no2 VARCHAR(30):='001';
  6.     rev VARCHAR(30);
  7.     l NUMBER;
  8. BEGIN
  9.     DBMS_OUTPUT.put_line('no => ' || no2);
  10.  
  11.     l:=LENGTH(no2);
  12.     FOR i IN REVERSE 1..l LOOP
  13.         rev:=CONCAT(rev,SUBSTR(no2,i,1));
  14.     END LOOP;
  15.  
  16.     DBMS_OUTPUT.put_line( rev|| ' is REVERS ');
  17.    
  18. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement