try:
create table b as
select serv_id,acct_id,acct_item_type_id,date,(select sun(charge) from a t
where a.date<=t.date) sun_charge from a;
create table b as
select serv_id,acct_id,acct_item_type_id,date,(select sun(charge) from a t
where a.date<=t.date) sun_charge from a;
select sum(charge) into v_sum from tablename where "date" <sysdate;
insert into table(...) values(....);不过个人觉得,加这个字段没有必要.因为你每条记录的值都可以算出来的.
create table b as
select serv_id,acct_id,acct_item_type_id,date,sum(charge) over(order by date) sun_charge from a;