ORACLE Óë ACCESS µ¼Êý¾ÝµÄÎÊÌ⣡
ORA Ïò ACCESS Öе¼Êý¾Ý£¬ÓõÄÊÇÊý¾Ý¹ÜµÀ£¡
ORAºÍACCESSµÄÁ¬½Ó·½Ê½£¬¶¼ÊÇODBCÁ¬½Ó£¡
PB°æ±¾ÊÇ PB6.5£¡
¿Í»§ÄDZßÔËÐÐʱ£¬³öÏÖ dbms odbc is not supported in your current installation µÄ´íÎ󣬲éÁËÏÂ×ÊÁÏÊÇȱÉÙÎļþ£¬
ĿǰÎÒ°Ñ pbdwe60.dll ºÍ pbvm60.dll ·Åµ½Ó¦ÓóÌÐòµÄĿ¼Ï£¬Í¬Ñù±¨ÏàͬµÄ´íÎó£¡
¶¼ÐèҪʲôÎļþ£¬ÐèÒª·ÅÔÚʲôλÖã¿
¶àл£¡¶àл£¡
²Î¿¼:
SQL code:
²»°²×°Oracle¿Í»§¶ËµÄÁ¬½Ó·½·¨
¡¡¡¡½üÀ´ÊÕÀ´²»ÉÙÍøÓÑÀ´ÐÅ£¬·´Ó³Ê¹Óñ¾·½·¨²»ÄÜÁ¬½ÓÊý¾Ý¿â¡£ ÎÒ¼ì²éÁËһϣ¬ÊÇÍøÓÑÍü¼Ç¼ÓÈëODBC¼°PowerBuilderµÄ¶¯Ì¬¿â.ÒÔPB7.0ΪÀý£¬Ìز¹³äÈçÏ£ºÇ뽫ÒÔÏÂÎļþ¿½±´µ½ÔËÐÐÎļþËùÔÚĿ¼£º
¡¡¡¡Ò»¡¢ODBC¶¯Ì¬¿â
¡¡¡¡ctl3d32.dll msvcrt40.dll odbc16gt.dll odbc32.dll odbc32gt.dll odbccp32.dll odbccr32.dll odbcint.dll
¡¡¡¡¶þ¡¢½¨Á¢EXTRA×ÓĿ¼£¬½«MSVCRT.DLLÎļþ¿½±´µ½¸Ã×ÓĿ¼ÏÂ
¡¡¡¡EXTRA\MSVCRT.DLL
¡¡¡¡Èý¡¢ORACLE¶¯Ì¬¿â¼°ÅäÖÃÎļþ
¡¡¡¡Tnsnames.ora CORE35O.DLL NASNSNT.DLL NAUNTSNT.DLL NCRNT.DLL Nlnt.dll NLSRTL32.DLL Nnfdnt.dll NNFNNT.DLL ¡¡¡¡NSNT.DLL NTNT.DLL NTTNT.DLL CIW32.DLL Ora73.dll OTRACE73.DLL Sqlnet.ora Sqltnsnt.dll CORE35.DLL
¡¡¡¡ËÄ¡¢PB¶¯Ì¬¿â
¡¡¡¡pbvm70.dll pbdwe70.dll Pbo7370.dll PBO8470.DLL pbodb70.dll libjcc.dll
ȱÉÙODBCÊý¾ÝÔ´Ö§³Ö£¡
°²×°oracleÁËÂð£¿
oracle°²×°ÓÐÎÊÌâÁË£¬odbcÀïÄܲâ³É¹¦Âð
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......