1.CURSOR c1 IS select sum(kc) as szc,vendor from spvdjxc where ddate='20020514' group by vendor having vendor
like myvendor;
改为:
CURSOR c1 IS select sum(kc) as szc,vendor from spvdjxc where ddate='20020514' and vendor like myvendor group by vendor ;
2.select c1_rec.szc+sum(jh+dr+ts+py_bc-(ls_pf_buy+DC_FC+tj+pk_bd_bs)) into c1_rec.szc
from spvdjxc where ddate>='20020515' and ddate<=enddate and vendor=c1_rec.vendor;
可以into cl_rec.szc吗?
3.spvdjxc表有按vendor的索引吗?
like myvendor;
改为:
CURSOR c1 IS select sum(kc) as szc,vendor from spvdjxc where ddate='20020514' and vendor like myvendor group by vendor ;
2.select c1_rec.szc+sum(jh+dr+ts+py_bc-(ls_pf_buy+DC_FC+tj+pk_bd_bs)) into c1_rec.szc
from spvdjxc where ddate>='20020515' and ddate<=enddate and vendor=c1_rec.vendor;
可以into cl_rec.szc吗?
3.spvdjxc表有按vendor的索引吗?
解决方案 »
- ORA-00947: 没有足够的值
- 求教:fedora10下面如何安装Oracle10g
- 请问两个数据接口,有一个标识次序不一样怎样导入,谢谢
- 有没有人去波科海姆科技面试过data analyse engineer 的职位啊
- 如何查看数据库中的索引建立情况
- asp 访问oracle 奇怪的事情?????
- oracle迁移到mysql如何解决rownum??
- 怎样用程序把一个数据库中的所有表名选出来
- 安装Oracle 8i (Release 3 (8.1.7) ) 的问题
- 目录服务问题急急急急急!
- Oracle系统预设的系统管理员都有什么不同!
- 主关键字如何由系统自动生成流水号?(大虾帮忙,更看在分数得面子上)
还有like也比较耗时。
建索引,ddate,vendor
dbms_output.put_line(..最好去掉,将结果保存到临时表中应该快些。