oracle×Ô¶¯±¸·Ý½Å±¾ÉèÖÃÎÊÌâ
#set Oracle User ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂ𣿠#set Node Name Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂ𣿠#set the Backup FileName¡¯s date RQ=¡¯date+%F-%H-%M¡¯ ÕâÊÇÔõô¶¨ÒåµÄʱ¼ä£¿RQÊǵ÷¶Èʱ¼äÉèÖÃÂ𣿠----------------------------------------- OraUser=¡±oracle¡± OraUserHome=¡±/home/oracle¡± User=¡±sys as sysdba¡± ÕâЩÊÇʲôÒâ˼£¿ Pass=¡±123213¡± Buffer=¡±10240¡± ----------------------------------------
UPÒýÓà ----------------------------------------- OraUser=¡±oracle¡± OraUserHome=¡±/home/oracle¡± User=¡±sys as sysdba¡± ÕâЩÊÇʲôÒâ˼£¿ --×÷Ϊ³¬¼¶¹ÜÀíÔ±Óû§À´½øÐвÙ×÷ Pass=¡±123213¡± Buffer=¡±10240¡± ---------------------------------------- OraUser=¡±oracle¡±ÕâÊÇSIDµÄÉèÖÃÂ𣿠OraUserHome=¡±/home/oracle¡±Õâ²»ÊÇ$ORACLE_HOMEµÄÒâ˼°É¡£ÕâÀïÉèÖõÄÊÇʲôĿ¼ User=¡±sys as sysdba¡± ÕâÊÇÒÔsysdbaÀ´µÇ½Âð£¿ÎªÊ²Ã´²»Ö±½Óд³ÉµÇ½Ãûsys Pass=¡±123213¡± Buffer=¡±10240¡± Õâ¸öÊÇÉèÖõÄʲô£¿ OraUserHome=¡±/home/oracle¡±Õâ¸ö¾ÍÊÇOR
Ïà¹ØÎÊ´ð£º
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn ×Ô¼º¶¥¡£¡£¡£ ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ! ²»ÖªµÀÓÐûÓÐ ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺ δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......