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Â¥µÄ˵·¨ ÎÒÅäÖÃÁ˼àÌý ½¨Á¢ÁËÒ»¸ö²âÊÔ¿â ×Ô¼ºÏÈÊÔÊÔÁË~
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......