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
Srinivas
zama
neha
Srinivas
Srinivas
Srinivas
prgm1
Example of Local and Global variables
Extract Year from Date Field Example
TRIGGER