这个是我写的过程,请各位指出哪里看逻辑读太多?如何解决?:oDECLAREn_comcntNUMBER;BEGINn_comcnt := 0 ;for c1 in (select * from TMP_SUBS where flag=0 and region=532 and mod(subsid,9)=0)LOOPn_comcnt := n_comcnt + 1;insert into stat_score_cust_liyuselect a.region,a.entityid,sum(decode(scorecycle,200701,a.balance,0)),sum(decode(SCORECYCLE,200601,EXTENDBALANCE,0) - OUTAMT),0from AM_BALANCE awhere a.region = 532and SCORECYCLE >= 200601 and a.entityid=c1.subs

每次月结时,因为要处理的数据都是实时变动的,很容易导致快照过旧的错误,只能通过备份成静态表来处理,但是备份成静态表,只能处理到备份前的数据,备份后的新数据处理不到,请问各位有没有什么办法规避此种问题?

今天看了个文档,其中有关于对临时表空间的限制有这样一句:不能下线.请教一下"不能下线"是什么意思?我看的文档不是英文的,英文的可能更好理解一点.:o

第2个cursor中的数据依赖于第1个cursor中的结果.DECLAREn_comcntNUMBER;BEGINn_comcnt := 0 ;for c1 in (select a.*,a.rowid from SUBSSCORE_DISCARD_SUBSOID_his a where flag=0 )LOOPn_comcnt := n_comcnt + 1;insert into am_score_reception_bakselect '2008012','',c1.region,c1.subsid,0,'',0,-b.inamt,'200712','ScoreChg',0,56,'11111',sysdate,'stcmNml',sysdate,0from am_score_balance bwhere b.scorecycle =substr(c1.statday,1,6)and b.entityid=c1.subsid

oidattrvaluetime88001999058747 53110 2008-1-14 16:32:4388001999092214 63310 2008-2-188001999594970 53810 2008-2-188001999746305 632632 2008-1-14 17:06:2188002000030660 20 2008-1-16 11:50:1388001999160937 2121 2008-2-188001999146525 518518 2008-1-14 16:37:1788001999161721 53110 2008-2-188001999633622 533533 2008-1-14 16:59:1088001999633622 533533 2008-2-188001999566893 51010 2008-1-14 16:59:5688001999177181 546546 2008-1-14 16:37:45880019

在一个包体中这句代码编译时报错insert into SUBSSCORE_DISCARD_SUBSOID(REGION,STATDAY,SUBSID)SELECT DISTINCT av_region,v_agio_day,subsid from yy_subs_privilegeWHERE region=av_region and startdateto_date(v_billcycle,'yyyymm').Error: PL/SQL: ORA-04052: error occurred when looking up remote object TBCS.SUBS_PRIVILEGE@DD2AORA-00604: error occurred at recursive SQL level 1ORA-12154: TNS:could not resolve service nameLine: 301Te

SQL> column servnumber format $999,9999,9999SQL> select servnumber from subscriber where region=057 and servnumber='03055300907';SERVNUMBER--------------------03055300907为什么是这样?我想得到的结果是$030,5530,0907

是不是我建的所有表都会再这里有记录?