ÈçºÎÈëÃÅORACLEÊý¾Ý¿â¿ª·¢
³õѧORACLE£¬Ö®Ç°¿´¹ýµÄ¶¼ÊÇЩ¹ÜÀí·½ÃæµÄÊ飬¹Ù·½Îĵµ¿´¹ýCONCEPTS,ADMINISTRATOR'S GUIDE£¨ÕýÔÚ¿´£© ¿ÉºÃÏñ¸Õ±ÏÒµ¾Í¸ã¹ÜÀí²»Ì«ÏÖʵ£¬²îµÄ֪ʶҲ»¹Í¦¶à£¬ËùÒÔÏë´Ó¿ª·¢ÏÈ×öÆð ×î½ü¿´µ½Óмҹ«Ë¾ÔÚÕÐORACLEÓ¦ÓÃÊý¾Ý¿â¿ª·¢µÄ£¬ÒªÇóÉÏдµÄÊÇ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡± ÎÒÏÖÔÚ¿´Ò»±¾ÖÐÎÄÊé½Ð¡¶ORACLE DATABASE 10G PL/SQL¡· Çë´ó¼Ò°ïÃ¦ÍÆ¼öÏÂÓÐûÓÐʲôºÃµãµÄÈëÃÅÊý¾Ý¿â¿ª·¢·½ÃæµÄ½Ì²Ä ºÇºÇ ˵À´²ÑÀ¢ ÎÒÉõÖÁ»¹²»Ì«Á˽âÊý¾Ý¿â¿ª·¢µ½µ×ÊÇ¿ª·¢³ö¸öʲô¶«Î÷À´ ×îºÃÍÆ¼öµÄÊéÉÔ΢±¡Ò»µã ÒòΪ¹À¼ÆÔµ×ÍøÉ꿪ʼ 10Ô¾ͱÊÊÔÁË
ÎÒ¿´µÄµÚÒ»±¾ÊéÊǸǹúÇ¿µÄ <ÉîÈëdz³öORACLE> »¹²»´í.. ¶ÔOracle ½á¹¹Õâ¿é½²µÄ»¹±È½Ïϸ£¬¿ÉÒÔ×öÈëÃŵÄÊé¿´£¬Â¥Ö÷×ö¿ª·¢µÄ»°£¬»¹µÄ¿´¿´Ð´SQL·½ÃæµÄ°É.. ÎÒÖ÷Òª¸ãά»¤Õâ¿é.. ֪ʶÊÇÂýÂý»ýÀ۵ģ¬ÒÔºó¾Í¶®µÄÔ½À´Ô½¶àÁË. ÒýÓà ÏÖÔÚ¿´µÄÕâ±¾Êé¾Í²»´í.Ò»ÃÅÐÄ˼¿´ºÃËü¾Í¿ÉÒÔÁË£¬±ðÔÙÕÒÆäËûÊéÁË¡£ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡± ÕâÊÇÄļҹ«Ë¾°¡£¬¼¼ÊõÌ«·ûºÏÎÒÁË ºÇºÇ °¢Àï°Í°ÍÒýÓà ÎÒ¿´µÄµÚÒ»±¾ÊéÊǸǹúÇ¿µÄ <ÉîÈëdz³öORACLE> »¹²»´í.. ¶ÔOracle ½á¹¹Õâ¿é½²µÄ»¹±È½Ïϸ£¬¿ÉÒÔ×öÈëÃŵÄÊé¿´£¬Â¥Ö÷×ö¿ª·¢µÄ»°£¬»¹µÄ¿´¿´Ð´SQL·½ÃæµÄ°É.. ÎÒÖ÷Òª¸ãά»¤Õâ¿é.. ֪ʶÊÇÂýÂý»ýÀ۵ģ¬ÒÔºó¾Í¶®µÄÔ½À´Ô½¶àÁË. ¶Ô ÎÒÏÖÔÚ¾ÍÊÇÏë¶ÍÁ¶Ò»ÏÂ×Ô¼ºÐ´SQLÄÜÁ¦ ÓÐʲôºÃµÄ½¨ÒéÂð ÓеÄʱºòÔÚÂÛ̳Àï¿´µ½Ò»Ð©Ìû×ÓÀïµÄSQLÎÒ¿´¶¼¿´²»¶® Î
Ïà¹ØÎÊ´ð£º
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Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý. Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø. µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
ÐÖµÜ Í¼¹ÒÁË¡£ <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value ......