ÏÖÔÚµÄSqlserverÊý¾Ý¿âÔõôÑùÄÜת»»³ÉOracleµÄ£¿
http://www.cnblogs.com/dragonpro/archive/2005/11/16/277473.html
ʹÓù¤¾ß°É¡£¼ÇµÃÒÔÇ°ÔøÊ¹ÓÃSQL SERVER 2000µÄDTS¹¤¾ß»¹ÊÇʲô¶«Î÷¸ã¹ýµÄ¡£
Õâ¸ö»°Ìâ´óÁË£¬¿ÉÄÜÐèÒª×Ô¼ºÊÖ¹¤Ò»¸ö¶ÔÏóÒ»¸ö¶ÔÏóÐÞ¸ÄתÈëÁË
ÎÒÊÇSqlserver2008רµ½Oracle11g£¬Ò²¿ÉÒÔÕâÑùÓÃÂð£¬ÓÐûÓмòµ¥µãµÄ¹¤¾ßѽ£¬ÎÒÊDzÂÏëһϣ¬ÕâÁ½¸öÊý¾Ý¿â¹¤¾ß¶¼ÊÇ×îÐµģ¬»¥×ªµÄ»°Ó¦¸ÃºÜ¼òµ¥°É,²»ÖªµÀÓÃʲô¹¤¾ß£¿
Êý¾Ý¿â×Ö¶ÎÀàÐͲ»Ò»Ö£¬Ã»ÓбêʾÁУ¬ÓÃÐòÁбíʾµÈµÈ
ËùÓеĽű¾£¨´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷µÈ£©¶¼ÐèÒªÖØÐÂд
ÒýÓà ÎÒÊÇSqlserver2008רµ½Oracle11g£¬Ò²¿ÉÒÔÕâÑùÓÃÂð£¬ÓÐûÓмòµ¥µãµÄ¹¤¾ßѽ£¬ÎÒÊDzÂÏëһϣ¬ÕâÁ½¸öÊý¾Ý¿â¹¤¾ß¶¼ÊÇ×îÐµģ¬»¥×ªµÄ»°Ó¦¸ÃºÜ¼òµ¥°É,²»ÖªµÀÓÃʲô¹¤¾ß£¿ ÎÞÂÛÓÃʲô¹¤×÷£¬×îºóËùÓеĽű¾£¨´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷µÈ£©¶¼ÐèÒªÖØÐÂд
²Î¿¼£º
http://school.itzcn.com/special-spid-35.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£
ÒýÓà Êý¾Ý¿â×Ö¶ÎÀàÐͲ»Ò»Ö£¬Ã»ÓбêʾÁУ¬ÓÃÐòÁбíʾµÈµÈ ËùÓеĽű¾£¨´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷µÈ£©¶¼ÐèÒªÖØÐÂд Ö§³Ö
ŶŶ~ºÃÏñͦÂé·³µÄ£¬ÎÒ»¹Ã»À´µÃ¼°ÊÔ£¬ÏÈлл¸÷λÁË¡£
½¨ÒéʹÓù¤¾ß½øÐгõ²½µÄת»»£¬µ«ÊÇ´æ´¢¹ý³Ì£¬´¥·¢Æ÷£¬ÄÚÖú¯ÊýµÈÐèÒªÖØ¹¹¡£Èç¹ûÔÚsql serverÖÐʹÓÃÁË´óÁ¿·Ç±ê×¼sqÓï¾ä£¬×ª»»¹¤×÷Á¿ºÜ´ó¡£
ѧϰÀ´µÄ
·¹ý
Ðֵܣ¬²»Òª¼ÄÏ£Íûת»»¹¤¾ßÁË£¬ÄÇÖ»ÄÜ´¦ÀíÏ൱¼òµ¥µÄ¶«Î÷¡¾±í½á¹¹¡¢Ö÷¼ü¡¢Ë÷ÒýµÈ¡¿£¬¶øÇÒ»¹²»Ò»¶¨ÕýÈ·¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......