windows ÏÂÃæoracle·þÎñÆ÷ instant clientµÄ°²×°
×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
http://www.oracle.com/technology/software/products/database/index.html
È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)
°²×°°üÒòÄãµÄ»úÆ÷ºÍ²Ù×÷ϵͳ¶øÒ죬ÎҵĻ·¾³ÊÇwindows 2003+AMD 64bit
ËùÒÔÎÒÑ¡ÔñÁËÉÏÃæÕâ¸ö°²×°°ü¡£
2.°²×°²½Ö裬һ·µ¥»÷ÏÂÒ»²½¼´¿É¼´¿É¡£
°²×°Íê³ÉÖ®ºóÐèÒªÔÚϵͳµÄ»·¾³±äÁ¿ÀïÃæÌí¼ÓһЩ±äÁ¿¡£·½·¨Îª£º
ÓÒ¼üµ¥»÷-ÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿->ÔÚϵͳ±äÁ¿¿òÏÂÃæµ¥»÷ н¨:È»ºóÌîÈë
±äÁ¿Ãû:ORACLE_HOME
±äÁ¿Öµ:E:\oracle\product\10.2.0\db_2(ΪÄãʵ¼Ê°²×°oracleµÄ·¾¶)
±äÁ¿Ãû:ORACLE_SID
±äÁ¿Öµ:(ΪÄãµÄÈ«¾ÖÊý¾Ý¿âÃû×Ö)
ÍêÁËÖ®ºóÖØÆô¼ÆËã»úʹ»·¾³±äÁ¿ÉúЧ¡£
ÕâÑù·þÎñ¶Ë¾Í°²×°okÁË¡£
¶þ.°²×°instant client;
1.¼ò½é£ºinstant clientÊÇŨËõ°æµÄ¿Í»§¶Ë£¬
ÆäÖÐBasic°ü ÊDZØÐë°²×°µÄ£¬È»ºóÄãÒª±à³ÌµÄ»°(Èçoci)£¬»¹ÐèÒªSDK°ü£¬ SQL*Plus×îºÃÒ²°²×°ÉÏ¡£
ÏÂÔØÒ³ÃæΪ£º
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
Ñ¡ÔñÄã»úÆ÷¶ÔÓ¦µÄ°æ±¾¡£
ÎҵĻ·¾³ÊÇwindows 2003+AMD 64bit£¬ËùÒÔÑ¡ÔñÁË
Instant Client for Microsoft Windows (x64)
2.½øÈ¥Ö®ºóÎÒÑ¡ÔñÈÃÁËVersion 10.2.0.3µÄbasic,sdk,sql*plus ÏÂÔØ(ºÃÏñҪע²á),È»ºó°ÑÕâЩÎļþ¶¼½âѹµ½
Ò»¸öÎļþ¼ÐÀïÃæ¡£
È»ºóÅäÖû·¾³±äÁ¿£º
±äÁ¿Ãû:PATH
±äÁ¿Öµ:F:\instantclient_10_2(ΪÄãʵ¼Ê°²×°oracle instant clientµÄ·¾¶)
È»ºóÖØÆô¼ÆËã»ú£¬°²×°over¡£
Ïà¹ØÎĵµ£º
Oracleµ÷ÓÅ×ÛÊö
ÔÚ¹ýÈ¥µÄÊ®ÄêÖУ¬ Oracle ÒѾ³ÉΪÊÀ½çÉÏ×îרҵµÄÊý¾Ý¿âÖ®Ò»¡£¶ÔÓÚ IT ר¼ÒÀ´Ëµ£¬¾ÍÊÇҪȷ±£ÀûÓà Oracle µÄÇ¿´óÌØÐÔÀ´Ìá¸ßËûÃǹ«Ë¾µÄÉú²úÁ¦¡£×îÓÐЧµÄ·½·¨Ö®Ò»ÊÇͨ¹ý Oracle µ÷ÓÅ¡£ËüÓдóÁ¿µÄµ÷Õû²ÎÊýºÍ¼¼ÊõÀ´¸Ä½øÄãµÄ Oracle Êý¾Ý¿âµÄÐÔÄÜ¡£
Oracle µ÷ÓÅÊÇÒ»¸ö¸´ÔÓµÄÖ÷Ìâ¡£¹ØÓÚµ÷ÓÅ¿ ......
¡¡¡¡1. Oracle°²裝Íê³ÉºóµÄ³õʼ¿ÚÁ
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
¡¡¡¡2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
¡¡¡¡administrator/administrator
¡¡¡¡3. oracle 8.0.5Ôõô´´½¨Êý¾Ý¿â£¿
¡¡¡¡ÓÃorainst¡£Èç¹ûÓ ......
http://blog.csdn.net/lzysystem/archive/2009/03/05/3960853.aspx
http://www.linuxidc.com/Linux/2009-06/20390.htm
http://www.linuxdiyf.com/viewarticle.php?id=163893
http://blog.sina.com.cn/s/blog_4ed66efa0100gfjx.html### ......
PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔÒò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øʹÓá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......
ÔÎĵØÖ·£ºhttp://arvinnan.javaeye.com/blog/308638
²Î¿¼
http://www.blogjava.net/wxqxs/archive/2008/10/13/237180.html?opt=admin
http://hi.baidu.com/ray315/blog/item/153c97a33cd26caacbefd0de.html
¶¨Òå
External tables access data in
external s ......