sql 2005ת oracle³ö´í
sql 2005ת oracle³ö´í
sql 2005ÓÐ3¸öimageÀàÐÍ£¬ תµ½ oracle blob³ö´í¡£ÓõÄÊÇSQLµÄµ¼Èëµ¼³ö¹¤¾ß
²é¿´ DTS Ïêϸ
²»ÐоÍÓôúÂëµ¼¡£
¿´À´Ö»ÄÜÓôúÂëÁË
°ï¶¥
jf
´úÂëÁ¿ ²»»áºÜ´ó°É
дÍêÁË Ìù³öÀ´ ѧϰÏÂ
ÎÒÏëÏȰѿÉÒÔÓÃSQL server2005Êý¾ÝÄܵ¼Èëµ½ORACLEµÄ×Ö¶ÎÏȵ¼È룬²»Äܵ¼ÈëµÄBLOB×Ö¶ÎÓôúÂë¸üÐÂupdate¡£²»ÖªµÀÄÜʵÏÖ²»
лл¥ÉÏÌáÐÑ
ÄÇclobͬÊôÓÚLObÀàÐÍ£¬ÎÒÔÚORACLEÖÐÓÃUPDATEclob×Ö¶Îû±¨´í£¬µ«¼ìË÷ÊÇȴûÏÔʾ¡£CLOB¸üÐÂÒ²ÊÇÄãµÄ·½·¨Âð£¿
clobµÄ»°Ö±½Ó¿ÉÒÔÔÚ³ÌÐòÖÐupdateµÄ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......