¶àл select a.JSJDM from DJ_NSRXX a inner join DJ_BG b on a.NSRBH = b.NSRBH and a.NSRZT_DM='Y' and a.SBDJBZ='N' and b.BGRQ between(trunc(add_months(last_day(SYSDATE)+1,-2))) and (trunc(last_day(add_months(SYSDATE,-1)))) inner join DJ_NSRXX_KZ c on b.NSRBH = c.NSRBH and c.KYRQ-b.BGRQ>30
¿´ÏûÏ¢£¬¿´ÏûÏ¢£¡ SQL code: select a.JSJDM from DJ_NSRXX a£¬ DJ_BG b£¬ DJ_NSRXX_KZ c where a.NSRZT_DM in ('Y','N') and a.SBDJBZ not in ('Y','N') and to_number(to_char(b.BGRQ ,'MM'))=to_number(to_char(sysdate,'MM'))-1 and b.BGRQ>c.DJ_NSRXX_KZ+30 and a.NSRBH=b.NSRBH and a.NSRBH=c.NSRBH
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......