OracleÖÐÊý¾Ýת¿â
Oracle ÖÐÓÐÒ»Êý¾Ý¿â dBOracle Êý¾Ý¿â±í tableOracle£¨time£¬data£© ±ðµÄÊý¾Ý¿â£¨·ÇOracleÊý¾Ý¿â£© dBOther Êý¾Ý¿â±í tableOther£¨time£¬data£© ÏÖÓÐÒÔÏÂÎÊÌ⣺ tableOracle ÖÐ ÓÐÊý¾Ý±ä»¯ tableother ÖÐ Á¢¼´¸ú×űä ÇëÎÊÓÐʲôºÃµÄ·½·¨ÊµÏÖÉÏÃæµÄ¹¦ÄÜ¡£ лл£¡
DBLINK ·ÇORACLEµÄÊý¾Ý¿â,ÄÇÊÇʲôÊý¾Ý¿â? tableOther¸ú×ű䣬Õâ¸ö°¡£¬ºÃÏñÒªµ½OtherÄǸöÊý¾Ý¿âÇøÈ¥Îʰɣ¬±Ï¾¹ÊÇother¸ú×ÅORACLE±ä Èç¹ûÊÇÓÃÊý¾Ý¿â¼¼ÊõÀ´×öµÄ»° ÐèÒªÁ˽âoracleµÄ͸Ã÷Íø¹Ø£¬dblinkºÍtriggerµÄ֪ʶ¡£ up ´¥·¢Æ÷+dblink+´æ´¢¹ý³Ì Èç¹ûÔÚÒ»¸ö¿âÖÐÓô¥·¢Æ÷¾ÍºÜºÃ½â¾öÁË¡£ ´¥·¢Æ÷+dblink ¿Ï¶¨Äܹ»½â¾öÎÊÌâ dblink+trigger ¸÷λ´óÏÀÏêϸµãºÃÂÎÒ¶ÔOracle²»ÔõôÊìϤ ¾ßÌåµÄTrigger ºÍ´æ´¢¹ý³Ì »¹ÓÐdblinkÔõôÓà ллÁË ¹Ø×¢ÖÐ,°³Ã»Óùý,ÌæÂ¥Ö÷¶¥,ÆÚ´ýÇ¿ÈË End_rbody_59954964//--> ¸Ã»Ø¸´ÓÚ2009-09-21 16:38:07±»°æÖ÷ɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP hul19830820 (ÍÀÁúµ¶) µÈ¡¡¼¶£º #12Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-09-23 15:49:43 ÔÚÕâÄѵÀ¾ÍûÓиßÈËÂð£¿ÎÒ²»¶¥Ò»Ï¶¼Òª³Áº£µ×ÁË¡£ ¸ßÈ˰ïæ°¡ÒýÓà Oracle ÖÐÓÐÒ»Êý¾Ý¿â dBOracle Êý¾Ý¿â±í tableOracle£¨time£¬data£© ±ðµÄÊý¾Ý¿â£¨·ÇOracleÊý¾Ý¿â£© dBOther Êý¾Ý¿â±í tableOther£¨time£¬data£© ÏÖÓÐÒÔÏÂÎÊÌ⣺ tableOracle ÖÐ ÓÐÊý
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ 2009-9-29 12:12:12 µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ Oracle in OraOdac11g_home1 11.01.00.07 ´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶ "D:\\app\\Ad ......
oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨ µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......