need script for adding number inside a tuple

Hi,
I'm new to SQL*PLUS and need a simple script, and explanation on how to add data(numbers) inside of one tuple. I did searches to look for sample scripts and was unable to locate any.
I believe that the data(number) must first be converted into characters and somekind of string manipulation must be done and a dual table must be used.
maybe i need to use to_char to convert number data??

select bar_id (the number inside bar_id must be added together) from dual;

I need to get the number inside bar_id to add together. example: bar_id=12345
I need a script to add: 1+2+3+4+5

any assistance is greatly appreciated. Received on Sat Oct 19 2002 - 11:20:43 CDT