oracleÊý¾Ý¿â°²È«ÐÔÎÊÌâ
Èç¹ûµÃµ½Ä³Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ,ÓÐûÓа취¿ÉÒÔ¶ÔÀïÃæËùÓÐµÄ±í½øÐвÙ×÷?
µÃµ½Ä³Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ? Èç¹ûÊÇËùÓÐÎļþ£¬¾Í¿ÉÒÔ»Ö¸´Êý¾Ý¿âÁË£¬ Êý¾Ý¿âopenÁË£¬Ïë¸Éɶ²»¾Í×Ô¼ºÖªµÀÁË.. ²»ÖªµÀÓû§ºÍÃÜÂëÒ²¿ÉÒÔ»Ö¸´Âð ¿ÉÒÔѽ.. ÃÜÂëÊÇ·ÅÔÚÒ»¸öÎļþÀïµÄ£¬Õâ¸öÎļþ¿ÉÒÔÓÃorapwd ÃüÁîÀ´Éú³ÉµÄ.. ÒýÓà ¿ÉÒÔѽ.. ÃÜÂëÊÇ·ÅÔÚÒ»¸öÎļþÀïµÄ£¬Õâ¸öÎļþ¿ÉÒÔÓÃorapwd ÃüÁîÀ´Éú³ÉµÄ.. ½öÓÐÊý¾ÝÎļþÊDz»Äָܻ´Êý¾Ý¿âµÄ£¬ ÖÁÉÙ»¹ÐèÒªredoÎļþ£¬controlÎļþ£¬×îºÃ»¹Òª´øÉϹ鵵Îļþ Õâô˵ Èç¹û½øÈë°²×°oracleÊý¾Ý¿âµÄ·þÎñÆ÷,ÄǾÍûÓÐÊ²Ã´ÃØÃÜ¿ÉÑÔÁË? ËùÓÐÊý¾ÝÎļþ£¿ Ï൱ÓÚÀ䱸»¹Ô£¬µ±È»¿ÉÒÔÁË...ÒýÓà Õâô˵ Èç¹û½øÈë°²×°oracleÊý¾Ý¿âµÄ·þÎñÆ÷,ÄǾÍûÓÐÊ²Ã´ÃØÃÜ¿ÉÑÔÁË? Ò»°ãµÄÉú²úϵͳҲ²»ÊÇÄÇôºÃ½øµÄ... ºÚ¿ÍÊÇÎ¥·¨µÄ.. ²éÁËÒ»µã×ÊÁÏ,¿´À´Ê²Ã´¶¼²»ÊǾø¶Ô°²È«µÄ.
Ïà¹ØÎÊ´ð£º
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ʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£ ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......