Re: need script for adding number inside a tuple

Please disregard my earlier post,I no longer need assistance. After much reading of SQL book I figured out solution to manipulating the data. :-)

thanks anyway.

pchcal_at_cs.com (Jane) wrote in message news:<322bb64a.0210190820.21480a28_at_posting.google.com>...
> 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 - 23:30:46 CDT