2012 年 6月 8 日随笔档案 - sumsen

摘要：看看和随便的区别阅读全文

posted @ 2012-06-08 23:52 sumsen 阅读(95) 评论(0) 推荐(0) 编辑

摘要： create or replace trigger updCust before update on bd_cubasdoc for each rowdeclare -- local variables here pk_bas char(20); /*查询目标公司是否存在基本档案*/ cursor basjob(id char) is select pk_cubasdoc from ncv5.bd_cubasdoc /*目标数据库表*/ where pk_cubasdoc = id and nvl(dr, 0) = 0;begin /*判断目标... 阅读全文

posted @ 2012-06-08 17:36 sumsen 阅读(403) 评论(0) 推荐(0) 编辑

NC查询增加表索引速度大增

摘要：来自南京一路http://www.itpub.net/thread-1621664-1-1.html原语句SELECT SUM (tb.bbye) FROM arap_djfb tb, arap_djzb th, bd_cumandocWHERE tb.vouchid = th.vouchid AND th.djdl = 'sk' AND th.djzt IN (1, 2, 3) AND th.dr = 0 AND tb.dr = 0 AND tb.wldx = 0 AND EXISTS ( SELECT climittypebid ... 阅读全文

posted @ 2012-06-08 11:52 sumsen 阅读(1550) 评论(0) 推荐(0) 编辑

SUMSEN