Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚoracle´æ´¢¹ý³ÌÎÊÌâ

ÓÐ3¸ö±í£¬DJ_NSRXX£¬DJ_BG£¬DJ_NSRXX_KZ£¬ËûÃǶ¼ÓÐÒ»¸öÒ»ÑùµÄÁУ¬NSRBH£¬Ó¦¸ÃÊÇÖ÷Íâ¼ü¹ØÏµ
²éѯÌõ¼þΪ

1¡¢ÄÉ˰ÈË״̬´úÂë(DJ_NSRXX µÚ17ÁУ¬NSRZT_DM  charÀàÐÍ 2λ)ÊÇÕý³£(Y/N)¡£
2¡¢°ìÀí˰Îñ±ä¸üÈÕÆÚ(DJ_BG µÚ4ÁÐBGRQ dateÀàÐÍ)ÔÚÉϸöÔ£¨²»°üº¬Éç±£µÇ¼Ç(DJ_NSRXX µÚ21ÁÐSBDJBZ charÀàÐÍ 2λֵΪY/N)£©¡£
3¡¢±ä¸üÈÕÆÚ(DJ_BG µÚ4ÁÐBGRQ dateÀàÐÍ)ÔÚ¹¤É̱ä¸üÈÕÆÚ(DJ_NSRXX_KZ µÚ22ÁÐKYRQ)30Ììºó

²éÕÒµÄÊÇÂú×ãÉÏÊöÌõ¼þµÄDJ_NSRXXµÄÁÐJSJDMµÄÖµ

¶àл

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

ÒýÓÃ
Ó¦¸ÃÊÇÖ÷Íâ¼ü¹ØÏµ£¿

ÕâÈý±íÖ®¼ä»¥ÏàÊÇÒ»¶ÔÒ»£¬Ò»¶Ô¶à»¹ÊǶà¶Ô¶àµÄ¹ØÏµÄØ£¿

»¹ÓÐÌõ¼þ2£¬3˵Ã÷µÄ̫ģºý£¬ÎÞ·¨Àí½â¡£


¿´ÏûÏ¢£¬¿´ÏûÏ¢£¡

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

²»ÖªµÀÊDz»ÊÇLZÏëÒªµÃ¡£¡£


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ