SUMSEN

摘要： 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 /*判断目标... 阅读全文

摘要： 来自南京一路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 ... 阅读全文