Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Reverse of a number
DECLARE num NUMBER; rev NUMBER; BEGIN num:=472; rev:=0; WHILE num>0 LOOP rev:=(rev*10) + mod(num,10); num:=floor(num/10); END LOOP; DBMS_OUTPUT.PUT_LINE('Reverse of the number is: ' || rev); END;
run
|
edit
|
history
|
help
0
test database table
DBMS
add pl/sql
testElham
if-else condition in pl/sql
Aditya ADMT
5
Srinivas
find if Xm % n is less than z and not equal to y.
SQLWithOuterAndInnerLoop_UnableToExecute