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
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
解决方案 »
- oracle不能录入中文
- 求教下面pl/SQl的写法
- oracle中一个小小的问题
- 请教下大数据量数据库存储设计
- 一些配置文件的编写规格,请帮忙
- 求就一条sql语句,100分结帐!!!!
- 如何去掉该列数据后的空格 例如 'A50520 ' 改成 'A50520' 给我一条sql语句?谢谢了
- 再来一贴,我创建的存储过程PLS-00905: 对象 JTJ.CARINFO 无效,帮忙看看
- SQL和ORCALE都有哪些字段类型,它们不同处在哪? 谢谢!
- 请教:Oracle Management Server为什么不能启动?
- PL/SQL developer里怎么查看游标指向的结果集?
- 一个较简单的函数编写出错.
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
bzszp(SongZip) 的方法不明白是什么意思,那为解说一番