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

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Â¥µÄ˵·¨ ÎÒÅäÖÃÁ˼àÌý ½¨Á¢ÁËÒ»¸ö²âÊÔ¿â ×Ô¼ºÏÈÊÔÊÔÁË~


Ïà¹ØÎÊ´ð£º

DelphiÔõôȡ·µ»ØÄÚÈÝÖеÄÖ¸¶¨²¿·Ö.

·µ»ØµÄÄÚÈÝÊÇÈçÏ´úÂë,ÔõôÄÜÇþµÀ2b?
<p class="text1">1a </p>
<p class="text1">2b </p>
<p class="text1">3c </p>
<p cl ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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 ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ