Oracle 中的视图定义问题

Question

create or replace view pv_p_put_butt as
select put_time,team_name,heat_numb,card_numb,stee_grad,spec,
butt_name ,count(id) js,sum(weight) zl ,wast_name
from p_p_put_butt  
where ....
group by put_time,team_name,heat_numb,card_numb,
stee_grad,spec,butt_name,wast_name

Answer 1

where 条件是根据日期，但是这个日期肯定是动态的

Answer 2

变相实现动态视图的方案：  
 
12:07:23 SQL> CREATE GLOBAL TEMPORARY TABLE TABLENAME (
12:07:24   2     COL1  VARCHAR2(10)
12:07:24   3  ) ON COMMIT DELETE ROWS ;表已创建。已用时间:  00: 00: 00.31
12:07:25 SQL> drop view v_tb;视图已丢掉。已用时间:  00: 00: 00.62
12:07:47 SQL> create view v_tb as
12:07:48   2  select * from tb where col2=(select col1 from tablename where rownum=1);视图已建立。已用时间:  00: 00: 00.31
12:07:49 SQL> select * from v_tb;未选定行已用时间:  00: 00: 00.00
12:08:08 SQL> select * from tb;COL1       COL2                           COLNEW
---------- ------------------------------ --------------------
1          aaa                            aaa
2          aaa                            aaa
3          aaa                            aaa
4          bba                            bba
5          bbb                            bbb
6          bbb                            bbc
7          bbb                            bbd
8          bbb                            ccc
9          bbb                            TEMP
10         bbb                            ddd已选择10行。已用时间:  00: 00: 00.46
12:08:13 SQL> insert into tablename values('bba');已创建 1 行。已用时间:  00: 00: 00.31
12:08:27 SQL> select * from v_tb;COL1       COL2                           COLNEW
---------- ------------------------------ --------------------
4          bba                            bba已用时间:  00: 00: 00.00
12:08:31 SQL> commit;提交完成。已用时间:  00: 00: 00.00
12:08:46 SQL> select * from v_tb;未选定行已用时间:  00: 00: 00.15

Answer 3

zmgowin(隐者(龙祖宗)) 和bzszp(SongZip)的方法都不错

Answer 4

ON COMMIT DELETE ROWS 这个是什么意思啊
bzszp(SongZip) 的方法不明白是什么意思，那为解说一番

Answer 5

当前session执行commit时自动清空临时表。

Answer 6

ks9960(snk) 理解能力也太差了吧

Answer 7

晕了，那 java200408你跟我讲一下嘛！谢谢！^-^