For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello There,
I would like to know how to write a SQL query to sum all digits in a given number.
example: Number is 123456
Sum is 21 = 1+2+3+4+5+6
Many thanks
Regards,
Don