Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÈëÃÅ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ÎÒ¿´¶¼¿´²»¶®
Î


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

ADO.NETµ÷ÓÃOracle´æ´¢¹ý³Ì?

Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼­.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ