具体的表和数据如下,现在问题是当有新数据插入之后,我也要动态显示出来,如何实现?
例如: 我插入这条数据
insert into expense(name,year,cost) values('owen',2008, 500);之后如何动态显示出来,oracle db 有什么好的方法来实现吗?drop table expense;create table expense (name varchar2(10), year number, cost number(8,2));insert into expense(name,year,cost) values('jacky', 2001, 100);insert into expense(name,year,cost) values('allen',2002, 200);insert into expense(name,year,cost) values('michael',2003, 300);insert into expense(name,year,cost) values('martin',2004, 400);commit;select name,
sum(decode(year,2001,cost,0)) year2001,
sum(decode(year,2002,cost,0)) year2002,
sum(decode(year,2003,cost,0)) year2003,
sum(decode(year,2004,cost,0)) year2004
from expense
group by name;
例如: 我插入这条数据
insert into expense(name,year,cost) values('owen',2008, 500);之后如何动态显示出来,oracle db 有什么好的方法来实现吗?drop table expense;create table expense (name varchar2(10), year number, cost number(8,2));insert into expense(name,year,cost) values('jacky', 2001, 100);insert into expense(name,year,cost) values('allen',2002, 200);insert into expense(name,year,cost) values('michael',2003, 300);insert into expense(name,year,cost) values('martin',2004, 400);commit;select name,
sum(decode(year,2001,cost,0)) year2001,
sum(decode(year,2002,cost,0)) year2002,
sum(decode(year,2003,cost,0)) year2003,
sum(decode(year,2004,cost,0)) year2004
from expense
group by name;
解决方案 »
- Oracle中的ST_FUNCS_ARRAY什么类型 和sql中的什么类型对应啊???
- Oracle where rownum语句与Order by的优先级
- pro*c为什么执行EXEC SQL WHENEVER NOT FOUND GOTO FAIL1;报错
- 一道非常难的sql查询题,请高手帮忙
- 如何修改SGA的大小
- oracle无法打开isqlplus
- 请问大家,我想在插入数据前先进行判断的SQL语句怎样写?
- 急!数据导入后的更新问题!
- 视图中能添加类似表中Comments吗?
- 求救!to_char(add_months(to_date(p.sum_period_date,'yyyymm'),-1),'yyyymm')
- oracle没有做备份,误删除后如何恢复
- 一个Oracle10G坏了,怎么把数据文件移动到另外一个Oracle10G去?
参考下,根据需要修改