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

ORACLE È¥³ýÖØ¸´¼Ç¼

      delete from tbl_talbe
      where (col1,col2,col3) in
     (select col1,col2,col3
       from tbl_table
       group by col1,col2,col3
       having count(*)>1)
     and rowid not in
     (
        select max(rowid)
        from tbl_table
        group by col1,col2,col3
        having count(*) >1
     )
    


Ïà¹ØÎĵµ£º

oracleµÄ·ÖÒ³¼¼Êõ

      ֮ǰÔÚÏîÄ¿ÖÐÓõ½µÄ·ÖÒ³¶¼ÊǼٷÖÒ³£¬Ò²¾ÍÊÇÏÈ´ÓÊý¾Ý¿âÖаÑËùÓеÄÊý¾Ý¶¼²éѯ³öÀ´È»ºóÔÚ°ó¶¨Ê±½øÐзÖÒ³¡£ÕâÊÇÒ»ÖÖ¼Ù·ÖÒ³£¬Ð§Âʽϵͣ¬Ç°¼¸ÌìÌýÆäËûÏîÄ¿×é˵ËûÃÇҪʹÓÃÊý¾Ý¿âµÄ´æ´¢¹ý³ÌÀ´ÊµÏÖ·ÖÒ³£¬¸Ð¾õºÜÒÉ»ó£¬ÄѵÀʹÓÃÊý¾Ý¿â»¹¿ÉÒÔʵÏÖ·ÖÒ³¹¦ÄÜ£¿ÏÐÀ´ÎÞÊ£¬¾Í´ÓÍøÉÏËÑÁËËÑ×ÊÁÏ£¬¹ûÈ»£¬ÔÚoracl ......

¡¾Ô­´´¡¿oracleµÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELO ......

oracle×Ö·û¼¯£¨×ª£©

ת×Ô£ºhttp://hi.baidu.com/66_com
ÒýÑÔ
ÎÒÏÖÔÚËùÔÚµÄÏîÄ¿×éÐèÒª°ÑmysqlµÄÊý¾Ý´¦Àíºóµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÔÚ´ËÆÚ¼äÓöµ½ÁËÊý¾ÝÖÐÎÄÂÒÂëÎÊÌâ¡£ÏÂÃæÊÇÎÒ¶ÔÕâ¸öÎÊÌâµÄ×ܽᡣ
1¡¢linux²Ù×÷ϵͳ£¬mysql£¬oracle°²×°Ê±×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎҵĽ¨ÒéÊÇÕâÈýÕßµÄ×Ö·û¼¯±£³ÖÒ»Ö£¬È«Îªutf-8»ògdk»ògb2312¡£Èç¹ûÓÐÌØÊâÒªÇó£¬ÈýÕß²»Í¬Ò² ......

oracleµÄociºÍthinÇø±ð

1£©´ÓʹÓÃÉÏÀ´Ëµ£¬oci±ØÐëÔÚ¿Í»§»úÉϰ²×°oracle¿Í»§¶Ë»ò²ÅÄÜÁ¬½Ó£¬¶øthin¾Í²»ÐèÒª£¬Òò´Ë´ÓʹÓÃÉÏÀ´½²thin»¹ÊǸü¼Ó·½±ã£¬ÕâÒ²ÊÇthin±È½Ï³£¼ûµÄÔ­Òò¡£
2£©Ô­ÀíÉÏÀ´¿´£¬thinÊÇ´¿javaʵÏÖtcp/ipµÄc/sͨѶ£»¶øoci·½Ê½,¿Í»§¶Ëͨ¹ýnative java methodµ÷ÓÃc library·ÃÎÊ·þÎñ¶Ë£¬¶øÕâ¸öc library¾ÍÊÇoci(oracle called interface ......

OracleÌåϵ½á¹¹Ö®£­Êý¾Ý¿â¡¢±í¿Õ¼ä¡¢ÊµÀý¼ò½é

Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£    
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼­Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼­Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼­ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ