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

Ò»¸öoracleµÄÃæÊÔÌ⣡±¾È˸Õѧoracle£¬ÇëÖ¸½Ì

Users±í
name gender salesid
ÕÅÈý Å® 1
ÀîËÄ Å® 2
ÍõÎå ÄÐ 3
ÁùСÁä Å® 1

sales±í
id name partid
1 ÊÛa ÏúÊÛ²¿
2 ÊÛb ÏúÊÛ²¿
3 ÊÛc Êг¡²¿
ÇëÓÃSQL²éÕÒ¸÷¸ö²¿ÃŵÄÄÐÅ®ÈËÊý·Ö±ðÊǶàÉÙ£¬ÈçÒÔÏÂÐÅÏ¢£º
Part ÄÐ Å®
ÏúÊÛ²¿ ?ÈËÊý ?ÈËÊý
Êг¡²¿ ?ÈËÊý ?ÈËÊý

select b.partid,a.gender,count(1)
from users a,sales b
where a.salesid=b.id
group by b.partid,a.gender

SQL code:
SELECT S.PARTID,SUM(DECODE(U.GENDER,'ÄÐ'£¬1£¬0)) ¡°ÄС±£¬SUM(DECODE(U.GENDER,'Å®'£¬1£¬0)) ¡°Å®¡±
from USERS U,SALES S
WHERE
U.SALESID=S.ID
GROUP BY S.PARTID;


²»ºÃÒâ˼£¬¿´µÄÂí»¢ÁË¡£
select b.partid,
      sum(a.gender, 'ÄÐ', 1, 0) ÄÐ,
      sum(a.gender, 'Å®', 1, 0) Å®,
  from users a, sales b
where a.salesid = b.id
group by b.partid


ÒýÓÃ
²»ºÃÒâ˼£¬¿´µÄÂí»¢ÁË¡£
select b.partid,
      sum(a.gender, 'ÄÐ', 1, 0) ÄÐ,
      sum(a.gender, 'Å®', 1, 0) Å®,
  from users a, sales b
where a.salesid = b.id
group by b.partid


ºÇºÇ ¸çÃÇÓÖÂí»¢ÁË
ÉÙ¸ödecode

select partid,max(decode(


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

´óÁ¬ÄļÒoracleÅàѵºÃ

Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡

¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡


Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......

oracleÄÚ´æÕ¼Óò»¶ÏÔö³¤ÎÊÌâ

Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿
Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡
¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡
which os ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ