oracle怎么新开账期,账期间隔问题（脚本写法）

加入表A有这样的数据

BANK_ID BILL     charge

304521 200705 20

304521 200706 20

304521 200707 20

304521 200708 20

304521 200710 20

304521 200711 20

304521 200712 20

304521 200801 20

304523 200803 10

304523 200805 10

304523 200809 10

304523 200810 10

304523 200811 10

304523 200812 10

304523 200901 10

304523 200902 10

我要得到这样的数据

BANK_ID  BILL                                                                      CHARGE

304521    200705-200708,200710-200801                           160

304523    200801,200803,200805,200809-200902                  80

这个语句要怎么去实现哈，有什么简单的方法

---------------------------

建表脚本

create table HSK_TEST_TABLE

(

BANK_ID     NUMBER,

BILL            VARCHAR2(6),

CHARGE      NUMBER

);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200705', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200706', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200707', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200708', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200710', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200711', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200712', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304521, '200801', 20);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200803', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200805', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200809', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200810', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200811', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200812', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200901', 10);

insert into HSK_TEST_TABLE (BANK_ID, BILL, CHARGE)

values (304523, '200902', 10);

commit;

[本帖最后由 hsk19880820 于 2009-4-9 21:26 编辑]