Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Â¥µÄ˵·¨ ÎÒÅäÖÃÁ˼àÌý ½¨Á¢ÁËÒ»¸ö²âÊÔ¿â ×Ô¼ºÏÈÊÔÊÔÁË~


Ïà¹ØÎÊ´ð£º

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

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

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

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

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

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ