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

OracleÖÐNOT INµÄÎÊÌâ

     ½ñÌìÔÚ¿ª·¢µÄʱºòÐèÒª²éѯÊý¾Ý¿âÖÐÄÄЩѧÉúÓжà¸öѧºÅ£¬Ð´µÄsqlÈçÏ£º
     select * from(
  select count(t1.xh) as xhs,t2.uuid,t3.xm as xsxm,t3.sfzjh, t1.xjzt as xjzt from hust_xs_jb t1
   INNER JOIN hust_xx_identity t2 on t1.sfid= t2.sfid
    INNER JOIN hust_xx_profile t3 on t2.uuid=t3.uuid group by t2.uuid ,t3.xm, t3.sfzjh, t1.xjzt order by t3.xm) t
  where xhs>=2 and xjzt not in('15','17','19','21','30','31','32','33','34','35','36','37','38','39','40','51','52','53','54')
²é³öµÄÊý¾ÝΪ¿Õ£¬µ«ÊÇÈ¥µôwhereÌõ¼þÖеĵڶþ¸öÌõ¼þ£¨Ò²¾ÍÊÇNOT INÌõ¼þ£©È´Äܲé³ö31ÌõÊý¾Ý£¬ÇÒÆäÖÐÖ»ÓÐÒ»ÌõµÄÊý¾ÝµÄXJZT×Ö¶ÎΪ33£¬ÆäËûµÄ¶¼Îªnull£¬Ó¦¸Ã²é³ö30ÌõÊý¾Ý°¡£¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ÄѵÀNOT  IN»á½«nullÖµ¹ýÂ˵ô£¿ÓÚÊǽ«sqlÉÔ¼ÓÐ޸ģº
     select * from(
  select count(t1.xh) as xhs,t2.uuid,t3.xm as xsxm,t3.sfzjh, t1.xjzt as xjzt from hust_xs_jb t1
   INNER JOIN hust_xx_identity t2 on t1.sfid= t2.sfid
    INNER JOIN hust_xx_profile t3 on t2.uuid=t3.uuid group by t2.uuid ,t3.xm, t3.sfzjh, t1.xjzt order by t3.xm) t
  where xhs>=2 and (xjzt not in('15','17','19','21','30','31','32','33','34','35','36','37','38','39','40','51','52','53','54') or xjzt is null)
¾ÍÄܲé³öËùÐèÒªµÄ30ÌõÊý¾ÝÁË¡£ÍøÉϲéÁËһϣ¬ËµOracle not in Èç¹û·µ»ØµÄÓÐnullÖµµÄ»°£¬¾Í²»»áÓмǼ¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE 11GR2 RAC new features ÐÂÌØÐÔ¡£

2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾­ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ¶àôºÃ£¬ÎÒÏàÐÅOracl ......

ʹÓÃoracle 10gÊý¾Ý¿â´´½¨½Å±¾ÊµÏÖÊÖ¶¯´´½¨Êý¾Ý¿â

×î½ü¹¤×÷ÉÔ΢±È½Ï¿ÕÏУ¬±ã°ÑʹÓÃDBCA ´´½¨Êý¾Ý¿âʱµÄÊä³öµÄ½Å±¾ÄÃÀ´Ñо¿Ñо¿£¬²¢²ÎÕսű¾Îļþ£¬ÊÖ¶¯ÊµÏÖÒ»¸öÊý¾Ý¿âµÄ´´½¨¹ý³Ì¡£Ê×ÏÈʹÓÃDBCA¹¤¾ß´´½¨Ò»·Ý½¨¿â½Å±¾£¬Õû¸ö½Å±¾Îļþ°üº¬ÈçÏÂÎļþ£¬
¸Ð¾õÓ¦¸ÃÊÇ´ÓBATÎļþ¿ªÊ¼ÈëÊÖ£¬´ò¿ªBATÎļþ²é¿´ÄÚÈÝÈçÏ£º
mkdir f:\oracle\product\10.2.0\admin\test\adump
mkdir f:\oracl ......

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......

OracleµÄÍⲿ±í

Íⲿ±í×÷ÓÃ:¼ÓÔØºÍÐ¶ÔØÊý¾Ý
Íⲿ±í¶¼ÊÇÖ»¶Á±í,²»ÄܽøÐÐupdate,insert,delete²Ù×÷.
Oracle ÌṩÁ½ÖÖ·ÃÎÊÇý¶¯: ORACLE_LOADER, ORACLE_DATAPUMP(oracle 10.2ºóÐÂÔöµÄÇý¶¯)
ORACLE_LOADER:    ËüÀûÓÃoracle loader¼¼Êõ´ÓÍⲿ±í¶ÁÈ¡Êý¾Ý. Ëü»¹¾ßÓÐÀàËÆSQL*Loader¹¤¾ß¿ØÖÆÎļþÓï·¨µÄÊý¾ÝÓ³ÉäÄÜÁ¦.
ORACLE_DAT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ