ÇëÍÆ¼öORACLEÈëÃÅÊé¼®
ÎÒ´ÓÊÂÁË7ÄêµÄSQL SERVER¹¤×÷ÁË£¬µ«ÊǶÔORACLEÒ»µã²»¶®¡£ Âé·³´ó¼ÒÍÆ¼ö±¾ORACLEÈëÃŵÄÊé¼®¡£¶àл£¡
ѧϰÏÂORACLE Ó¢ÎÄ¿ÉÒԵϰ¿´¿´¹Ù·½ÎĵµCONCEPTS ÓÐÄÇô¾ÃµÄÊý¾Ý¿âʹÓþÑéÁË ºÇºÇ Ó¦¸Ã²»ÄÑÒýÓà ѧϰÏÂORACLE www.itpub.netÒýÓà ӢÎÄ¿ÉÒԵϰ¿´¿´¹Ù·½ÎĵµCONCEPTS ÓÐÄÇô¾ÃµÄÊý¾Ý¿âʹÓþÑéÁË ºÇºÇ Ó¦¸Ã²»ÄÑ Ó¢ÎĺܲºÇºÇ¡£¡£ ¶ÔORACLEÒ»Çϲ»Í¨£¬ÏëÂò±¾ÖÐÎÄÈëÃŵÄÊé¼®¡£´ó¼ÒÍÆ¼öÏ¡£ ÊǹÜÀí»¹ÊÇ¿ª·¢·½ÃæµÄѽ¡£ ¿ÉÒÔµ½inthirtiesÂÛ̳Àï¿´¿´¡£ Ö÷ÒªÏëѧϰ¹ÜÀí ¿ª·¢µÄ»°Ó¦¸ÃºÍTSQL²î±ð²»´ó¡£ ITPUBÊÇOracleѧϰºÃÍøÕ¾£¡~ 7ÄêµÄSQL SERVER¹¤×÷£¬¸ßÊÖ°¡£¬±¾ÈËÒ²Ïëѧϰ¹þOracle£¬ÂòÊ齨Òéµ½µ±µ±ÉÏ¿´¿´£¬Äã»áÕÒµ½²»´íÂúÒâµÄ¡¡ ºÜ¶à²»´íµÄÊé¶¼ÅÅÔÚÇ°ÃæµÄ¡¡
Ïà¹ØÎÊ´ð£º
ÎÒ¶Ô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 ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º .....from table_name@cxdb_link Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿ Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡ ¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡ which os ......