Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ÖÐ ÓÐÊý


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°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°²×°ÎÊÌâ

oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨

µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö

ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ