¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ÄãÔÙÖØÐ°²×°ÊÔÊÔ ±¨µÄÊÇʲô´íÎó£¿ ÊDz»ÊÇ֮ǰװ¹ý£¿
http://topic.csdn.net/u/20090626/11/ece71a6b-fae4-4860-8e6d-4345ae9aac83.html
ÔÚ°²×°¿ªÊ¼Ê±£¬OracleÒª¶Ôϵͳ½øÐмì²âÓÐÍø¿¨µÄÑ¡Ïîûͨ¹ý¼ìÑ飬ÓÚÊÇÎÒÊÖ¹¤¶Ô¸ÃÏî´òÁË¡Ì £¬ÏÔʾÒÑÅäÖã¬ÕâÑù±ã¿ªÊ¼ÁËËùνµÄÕý³£°²×°¡£
»òÕß
ÉèÖá°Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷¡±£¬ÓÚÊÇÎÒ¾ÍÊÖ¹¤¼ÓÁËÒ»¸ö£¬¾ßÌå·½·¨Ï£º
´ò¿ª¡°¿ØÖÆÃæ°å¡±£¬Ë«»÷¡°Ìí¼ÓÓ²¼þ¡±Í¼±ê£¬ÔÚ¡°Ìí¼ÓÓ²¼þÏòµ¼¡±Öе¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬¸ÃÏòµ¼»áËÑË÷×î½üÁ¬½Óµ½¼ÆËã»úµ«ÉÐδ°²×°µÄÐÂÓ²¼þ¡£ÓÉÓÚÎÒÃDz¢Ã»ÓÐÕæÕýΪ¼ÆËã»úÁ¬½ÓеÄÓ²¼þ£¬ËùÒÔϵͳµ±È»ÎÞ·¨ÕÒµ½ÐÂÓ²¼þ£¬Òò´Ë»áµ¯³öÒ»¸öѯÎÊÓ²¼þÊÇ·ñÒѰ²×°µÄ¶Ô»°¿ò£¬ÔڸöԻ°¿òÖÐÑ¡Ôñ¡°ÊÇ£¬ÎÒÒѾÁ¬½ÓÁË´ËÓ²¼þ¡±£¬µ¥»÷ ¡°ÏÂÒ»²½¡±°´Å¥¡£
1¡¢ÔÚ³öÏֵġ°ÒѰ²×°µÄÓ²¼þ¡±ÁбíÖУ¬Ñ¡Ôñ×îºóÒ»Ïî¡°Ìí¼ÓеÄÓ²¼þÉ豸¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼ÌÐø¡£
2¡¢ÔÚ½ÓÏÂÀ´µ¯³öµÄ¶Ô»°¿òÖУ¬Ñ¡Ôñ¡°°²×°ÎÒÊÖ¶¯´ÓÁбíÖÐÑ¡ÔñµÄÓ²¼þ¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬ÔÚ³öÏÖµÄÓ²¼þÁбíÖÐÑ¡Ôñ¡°ÍøÂçÊÊÅäÆ÷¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¡£
3¡¢ÔÚÑ¡ÔñÍø¿¨¶Ô»°¿òÖУ¬¡°³§ÉÌ¡±Ñ¡Ôñ¡°Microsoft¡±£¬¡°Íø¿¨¡±Ñ¡Ôñ¡°Microsoft Loopback Adapter¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼´¿É¿ªÊ¼°²×°£¬×îºóµ¥»÷¡°Íê³É¡±°´Å¥¡£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......
abnormal end of export file IMP-00028: partial import of previous table rolled back: 3828 rows rolled back ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿ ignore=y Äã² ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º ID Name 1 Jack,Tom,Ben 2 Mary,Simth,Tony,Jay ת»»Îª£º ID Name 1 Jack 1 Tom 1 Ben 2 Mary 2 Simth 2 Tony 2 Jay ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£© ±í½á¹¹£º ¿¨ºÅ£ºNUMBER(10) »ùÕ¾£ºVARCHAR2(20) ʱ¼ä£ºDATE ³öÈë±êÖ¾£ºVARCHAR2(1) ±íÊý¾Ý ¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......