Re: [A] tab_a (4+4+4) -> tab_b (12)

Try:
insert into table_b (calc_sums)
select to_number(column_a_column_name) from table_a;

This will only work if you have valid data in your column_a_column

In Article<468oht$oeb$1_at_mhadf.production.compuserve.com>, <75363.640_at_CompuServe.COM> write:
>
> There was a post here recently about a table with a column (type
> varchar) populated by values like '4+4+4', '3+1', '1+9+22+3+4'.
> The poster wanted to know if there was a way to insert the
> calculated sums of the entries into another table.
> Something like:
> insert into table_b (calc_sums)
> select arith_string from table_a;
Received on Mon Oct 23 1995 - 00:00:00 CET