DelphiÈçºÎÓëoracleÁ¬½Ó
ÒÔǰһֱÓõÄÊÇSQL SERVER
µ½Á˵¥Î»£¬Êý¾Ý¿âÓõÄÊÇoracle£¬ÍøÉÏ¿´ÁËЩÌû×Ó£¬»¹ÊÇÓÐЩ²»Ã÷²»°×£¬ÄÄλÓÐÏêϸµãµÄ²½ÖèµÄ
¶Ë¿Ú1521 IPÊÇ192.168.0.1¾ÙÀýÈç´Ë£¬ÔõôÁ¬½Ó¡£
Ò»°ãÐèÒªÏȰ²×°oracle¿Í»§¶Ë,¸ù¾ÝÇé¿ö,¿ÉÒÔÑ¡ÔñÐÔµÄ×°oracleµÄodbc/oledbÇý¶¯
Ò»°ãÇé¿öÏÂÒªÏÈ×°Oracle¿Í»§¶Ë²ÅÄÜÁ¬¡£ÓÃADO£¬DBX¶¼ÄÜÁ¬£¬²»¹ýÎÒ¶¼ÊÇÓÃODACµÄ£¬»òÕßDAO(Direct Oracle Access)
¿Í»§¶ËÒѾ°²×°ÁË net manager Ò²ÅäÖùýÁË
Ö»Êǵ¥´¿µÄ¶ÔÓÚoracle²»ÊìϤ ºÜ¶àϸ½ÚÎÊÌâ¶¼»¹Ã»¸ãÇå³þ
Oracle¾ÍÊDZȽÏÂ鷳Щ
¶øÇÒÓÃBDE²é´óÁ¿Êý¾Ýʱ»áºÜ¿ì
Êý¾ÝÁ¿Ì«´ó ÊDz»ÊÇ¿ÉÒÔ¿¼ÂÇд¸öË÷Òý
°²×°¸ö¿Í»§¶Ë£¬ÅäÖøöÊý¾ÝÔ´£¬È»ºóADOÁ¬½Ó¾Í¿ÉÒÔÁË£¬ºÍÁ¬SQLServer²î²»¶à°Ñ
oracleºÍSQL ÓÐÇø±ðµÄ Êý¾ÝÔ´ÄÇÀïÎÒ²»»áÅäÖÃ
°´5Â¥µÄ˵·¨ ÎÒÅäÖÃÁ˼àÌý ½¨Á¢ÁËÒ»¸ö²âÊÔ¿â ×Ô¼ºÏÈÊÔÊÔÁË~
Ïà¹ØÎÊ´ð£º
·µ»ØµÄÄÚÈÝÊÇÈçÏ´úÂë,ÔõôÄÜÇþµÀ2b?
<p class="text1">1a </p>
<p class="text1">2b </p>
<p class="text1">3c </p>
<p cl ......
±¾À´ÒªÐ´¸ö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 ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......