Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â»ñÈ¡µ±Ç°Óû§Á¬½ÓÊýµÄsqlÓï¾ä

¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session  #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes  #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â  #ÐÞ¸ÄÁ¬½Ó ......

ÅöÉÏoracle×Ö·û¼¯ÎÊÌâ

ǰ̨UI½ø³Ì£¨VC6±àд£©½«UTF-8ÖÐÎÄ·¢¸øºǫ́·þÎñ³ÌÐò£¨Linux GCC£©£¬ºǫ́ÔÙдÈëoracleÊý¾Ý¿â£¬È»ºóǰ̨ÔÙͨ¹ýºǫ́½«Êý¾ÝÈ¡³ö£¬²¢ÏÔʾ£»ºǫ́ûÓÐ×ö±à½âÂëת»»£¬Ç°Ì¨ÔòÔÚVCĬÈϵÄGBKÓëUTF-8Ö®¼ä×÷ת»»¡£
¿ªÊ¼Ê±ÏµÍ³³öÏÖÂÒÂ룬ºóÀ´Í¨¹ýÉèÖÃLinuxÒ»¸ö»·¾³±äÁ¿¡¢ÖØÆôºǫ́½ø³ÌÎÊÌâ½â¾ö£¨ÎÊÌâÊÇÔø¾­³¢ÊÔ¹ý¸ü¸Ä¸Ã»·¾³±äÁ¿£¬µ«ÂÒÂëÒÀ ......

OracleÖг£ËµµÄHA¡¢RAC¡¢DataguradµÄÇø±ð

HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·­Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨È ......

Oracle SQL ÓÅ»¯

Oracle
SQL
µÄÓÅ»¯¹æ
Ôò£º
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ
        ÓÃINд³öÀ´µÄSQL
µÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬µ«ÊÇÓÃINµÄSQL
ÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓORACLE
Ö´
ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQL
Óë²»ÓÃINµÄSQL
ÓÐ
ÒÔÏÂÇø±ð£º
    ......

OracleÖÐÓÅ»¯SQLµÄÔ­Ôò

.Frm644 { display:none; }
¡¡¡¡1¡£ÒѾ­¼ìÑéµÄÓï¾äºÍÒÑÔÚ¹²Ïí³ØÖеÄÓï¾äÖ®¼äÒªÍêȫһÑù
¡¡¡¡2¡£±äÁ¿Ãû³Æ¾¡Á¿Ò»ÖÂ
¡¡¡¡3¡£ºÏÀíʹÓÃÍâÁª½Ó
¡¡¡¡4¡£ÉÙ
Óöà²ãǶÌ×
¡¡¡¡5¡£¶àÓò¢·¢
¡¡¡¡
¡¡¡¡Óï¾äµÄÓÅ»¯²½ÖèÒ»°ãÓУº
¡¡¡¡1¡£µ÷ÕûsgaÇø£¬Ê¹µÃsgaÇøµÄÊÇÓÃ×îÓÅ¡£
¡¡
¡¡2¡£sqlÓï¾ä±¾ÉíµÄÓÅ»¯£¬¹¤¾ßÓÐexplain,sql trace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ