¸÷λ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¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼´¿É¿ªÊ¼°²×°£¬×îºóµ¥»÷¡°Íê³É¡±°´Å¥¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿ Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É SQL> select name from v$database; NAME --------- ORCL
......