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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ¶àôºÃ£¬ÎÒÏàÐÅOracl ......
×î½ü¹¤×÷ÉÔ΢±È½Ï¿ÕÏУ¬±ã°ÑʹÓÃDBCA ´´½¨Êý¾Ý¿âʱµÄÊä³öµÄ½Å±¾ÄÃÀ´Ñо¿Ñо¿£¬²¢²ÎÕսű¾Îļþ£¬ÊÖ¶¯ÊµÏÖÒ»¸öÊý¾Ý¿âµÄ´´½¨¹ý³Ì¡£Ê×ÏÈʹÓÃDBCA¹¤¾ß´´½¨Ò»·Ý½¨¿â½Å±¾£¬Õû¸ö½Å±¾Îļþ°üº¬ÈçÏÂÎļþ£¬
¸Ð¾õÓ¦¸ÃÊÇ´ÓBATÎļþ¿ªÊ¼ÈëÊÖ£¬´ò¿ªBATÎļþ²é¿´ÄÚÈÝÈçÏ£º
mkdir f:\oracle\product\10.2.0\admin\test\adump
mkdir f:\oracl ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......
Íⲿ±í×÷ÓÃ:¼ÓÔØºÍÐ¶ÔØÊý¾Ý
Íⲿ±í¶¼ÊÇÖ»¶Á±í,²»ÄܽøÐÐupdate,insert,delete²Ù×÷.
Oracle ÌṩÁ½ÖÖ·ÃÎÊÇý¶¯: ORACLE_LOADER, ORACLE_DATAPUMP(oracle 10.2ºóÐÂÔöµÄÇý¶¯)
ORACLE_LOADER: ËüÀûÓÃoracle loader¼¼Êõ´ÓÍⲿ±í¶ÁÈ¡Êý¾Ý. Ëü»¹¾ßÓÐÀàËÆSQL*Loader¹¤¾ß¿ØÖÆÎļþÓï·¨µÄÊý¾ÝÓ³ÉäÄÜÁ¦.
ORACLE_DAT ......