Hi,
I have Number like : 1125.26
Can you help me to syntax return 26 (fractional number).
Printable View
Hi,
I have Number like : 1125.26
Can you help me to syntax return 26 (fractional number).
SQL> select mod(1125.26, 1)*100 fraction from dual;
FRACTION
---------
26
Thanks jmodic,
Good Idea.