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

Àä¾²ÏÂÀ´£¡ÈÃÎÒÃÇ˼¿¼Oracle¶ÔÓÚSunµÄ²úÆ·²ßÂÔ

Ô­·¢±íÓÚhttp://saharabear.javaeye.com
 ºÍhttp://www.haulynjason.net(Ó¢)
ͬʱ·¢±íÔÚÕâÀï.
´óÔ¼°ëÄêǰ£¬Oracle¹«Ë¾Ðû²¼£¬ËüÏëÊÕ¹ºSun£¬×òÌìµÄʱºò,Oracle¹«Ë¾Ðû²¼Íê³É¶ÔSun΢ϵͳµÄÊÕ¹º¡£×÷ΪJava³ÌÐòÔ±£¬ÎÒÃÇ´ó¼Ò¶¼·Ç³£¹Ø
ÐĵÄÊÇSun²úÆ·£¬°üÀ¨Java£¬Netbeans£¬Glassfish£¬Solaris/
OpenSolaris£¬OpenOffice£¬VirtualBox£¬JavaFX£¬Kenai.com¡£Ç°Ò»¶Îʱ¼ä£¬ÎҺܵ£ÐÄÕâЩ²úÆ·µÄδÀ´£¬ÎÒ»¹ÄÜ
¹»Çå³þµØ¼ÇµÃBEA
devµÄÉçÇøÍøÕ¾Ïûʧ¡£ÏÖÔÚ£¬Oracle¹«Ë¾Ëƺõ¹«²¼ÁËËüµÄ²ßÂÔ£¬µ«ÎÒÎÞ·¨¿´µ½Webcase£¬²»Çå³þÊÇÒòÎªÍøËÙÎÊÌ⻹ÊÇÆäËûÎÊÌâ.
¾­¹ý10·ÖÖÓÔڹȸèËÑË÷Ïà¹ØÄÚÈݺó£¬ÎÒ·¢ÏÖÎÒÎÞ·¨»ñµÃ×ã¹»¶àµÄÐÅÏ¢¡£ºÃ°É,ÎҾ͵±ÕâʽáÊøÁË,ÏÖÔÚÖ»ÐèÒªÀä¾²ÏÂÀ´£¬ÈÃÎÒÃÇ˼¿¼Ò»ÏÂ.
Java
JavaµÄ²»½öÊÇÒ»ÖÖÓïÑÔ£¬²»½öÊÇÒ»¸öƽ̨£¬²»½öÊÇÒ»¸ö²úÆ·£¬ËüÊÇÒ»¸öÊÀ½ç£¬ÊÜGNU¹«¹²Ðí¿ÉÖ¤µÄ±£»¤¡£ÎÒÃÇÐèÒªµ£ÐÄJavaÂð?ÎÒ²»µ£ÐÄ,Ò»µãÒ²²»µ£
ÐÄ.JavaÊÇÊÀ½çÉÏĿǰ×î´óµÄÓïÑÔ£¬Èç¹ûOracleÊDz»ÊÇÌ«ÓÞ´À£¬JavaÓïÑÔ½«¼ÌÐøÔö³¤£¬×÷ΪһÖÖÓïÑÔ£¬×÷Ϊһ¸öƽ̨£¬×÷Ϊһ¸ö²úÆ·£¬Í¬Ê±Ò²×÷Ϊһ
¸ö²úÒµÁ´¡£JDK7£¿JavaEE7£¿Õâ²»ÊÇÎÊÌ⣬ÎÒÃÇÐèÒª3-4ÄêÒÔÉÏÈ¥Éý¼¶Ô­À´µÄJ2EE1.4£¬JavaEE5µ½JavaEE6£¬Ò²ÐíÎÒÃÇ»¹ÐèÒª
3-4ÄêµÄʱ¼ä¿¼ÂÇÊDz»ÊÇÒªÉý¼¶JavaEE7£¨JavaEE7?£©¡£Ë­¿ÉÒÔ¿´µ½ÐÅϢʱ´úµÄδÀ´10Äꣿ²»Òªµ£ÐÄ£¬JavaÊÇ×ã¹»µÄÎȶ¨µÄºÍ¸»ÓÐÉú²úÁ¦
µÄ£¬Õâ²ÅÊÇ×îÖØÒªµÄ¡£
Netbeans
ÕâÊÇÎÒ×îϲ»¶µÄIDE£¬ÎÒÿÌìÓÃËü¿ª·¢JavaSE£¬JavaEE£¬±¨±íºÍJavaFX¡£ÄÇôËü»áÓÐʲôÑùµÄǰ;£¿ÎÒûÓÐÔÚNetbeansµÄÓʼþÁбíÖÐ
¿´µ½ºÜ¶à¹ØÓÚÕâ·½ÃæµÄÌÖÂÛ,µ«¸ù¾Ý¿´µ½µÄһЩÐÂÎÅ£¬Ò²ÐíOracle²»»á·ÅÆúNetbeansµÄ£¬µ«¿´ÆðÀ´OracleËÆºõ²»Ïë°ÑËüµ±×÷×îÖØÒªµÄIDE²ú
Æ·È¥Ö§³Ö,ÒÀÈ»ËÀÊØ×ŸÃËÀµÄJDeveloper¡£±ðÍüÁË£¬NetBeansÊǷdz£·Ç³£ÊÜ»¶Ó­µÄ¿ª·¢¹¤¾ß,Netbeans¿ÉÒÔÍêÃÀÖ§³Ö
J2EE1.4£¬JavaEE5ºÍJavaEE6£¬ÕýÈçÎÒ˵µÄJavaµÄÎÊÌ⣬ÎÒÃDz»ÐèÒªµ£ÐÄ7-8ÄêºóµÄÇé¾°£¬Ö»ÐèÒª¹Ø×¢µ±Ç°£¬NetBeans
6.7.1ºÍNetbeans 6.8ÔÚĿǰµÄ״̬ÏÂÒѾ­ºÜÍêÃÀ,ÎÒÃDz»ÐèҪ̫µ£ÐIJ»´æÔڵķçÏÕ¡£
Glassfish
GlassfishµÄV2.1°æ±¾£¬ÒѾ­·Ç³£Îȶ¨£¬V3Ò²ºÜºÃ£¬µ«»¹²»¹»Îȶ¨.ÄãÐèÒªÒ»¸öûÓм¯ÈºÖ§³ÖµÄJavaÓ¦Ó÷þÎñÆ÷Âð?²»Òª¸æËßÎÒÓÃWeb
ProfileÔÚWeb²ãÓÃEJB£¬JavaEE6ÊÇδÀ´µÄ£¬JavaEE5ÊǽñÌì¡£¶øÄãÐèÒªÊ²Ã´ÄØ?GlassfishµÄV2.1°æ±¾¾ÍÒѾ­×ã¹»Âú×ãÄã
µÄÐèÒªÁË.Oracle¹«Ë¾ÓµÓÐWebLogic£¬Õâ¸öÓÖÀÏ£¬Óִ󣬻ºÂýºÍ°º¹óµÄÓ¦Ó÷þÎñÆ÷£¬ÎÒÃÇÈÏΪ£¬Oracleϲ»¶Ò


Ïà¹ØÎĵµ£º

oracle 10gÖÐºÜÆæ¹ÖµÄµ¥ÒýºÅÎÊÌâ

 
oracleÖУ¬
±í½á¹¹ÈçÏ£º
create table device
(
 id number(10) not null primary key,
 dept varchar2(50)  not null
)
tablespace users
/
 
Òª½«dept×ֶθüгÉÈçÏÂÄÚÈÝ£ºselect * from message where name='tom'
ÎÒÊÔ¹ýʹÓÃÈçϵĸüÐÂÓï¾ä²»ÐУºupdate device set dept='selec ......

Oracle ´æ´¢¹ý³Ì ¶¨Òå ºÍ Óŵã

 
¶¨Ò壺
´æ´¢¹ý³Ì£¨Stored Procedure £©ÊÇÒ»×éΪÁËÍê³ÉÌØ¶¨¹¦ÄܵÄSQL Óï¾ä¼¯£¬¾­±àÒëºó´æ´¢ÔÚÊý¾Ý¿âÖС£Óû§Í¨¹ýÖ¸¶¨´æ´¢¹ý³ÌµÄÃû×Ö²¢¸ø³ö²ÎÊý£¨Èç¹û¸Ã´æ´¢¹ý³Ì´øÓвÎÊý£©À´Ö´ÐÐËü¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿âÖеÄÒ»¸öÖØÒª¶ÔÏó£¬ÈκÎÒ»¸öÉè¼ÆÁ¼ºÃµÄÊý¾Ý¿âÓ¦ÓóÌÐò¶¼Ó¦¸ÃÓõ½´æ´¢¹ý³Ì¡£ ´æ´¢¹ý³ÌÊÇÓÉÁ÷¿ØÖƺÍSQL Óï¾äÊéдµÄ¹ý ......

¡¾×ª¡¿ Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷

Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½,¼´»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)ºÍ»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO)£¬ÔÚOracle8¼°ÒÔºóµÄ°æ±¾,OracleÇ¿ÁÐÍÆ¼öÓÃCBOµÄ·½Ê½
    RBO·½Ê½£ºÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñÑ­µÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹ ......

redhat5Éϰ²×°oracle»·¾³ÅäÖÃ

red hat enterprise linux 5 »·¾³ÏÂOracle10g
Ò»¡¢°²×°Ç°µÄ×¼±¸¹¤×÷
1¡¢ÏÂÔØoracle_database_10.2.0.1.0 for linux °²×°³ÌÐò£º
ÏÂÔØµØÖ·£ºhttp://202.197.127.197/libweb/down.asp£¨×¢Òâ°²×°ÎļþµÄ°æ±¾ºÅ£©
2¡¢½âѹÈí¼þ£º
½«ORACLE°²×°Ñ¹Ëõ°ü½âѹ£¬µÃµ½oracle_database_10.2.0.1.0.Ŀ¼
3¡¢ÉèÖúËÐIJÎÊý£º
ÔÚ/etc/sy ......

Oracle ¿ìÕÕ¼° dblinkʹÓà £¨Á½Ì¨·þÎñÆ÷Êý¾Ýͬ²½£©


--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
--          Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
/*Ò»¡¢´´½¨dblink£º*/
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblin
drop database link dblink_anson;
Create public
database link dblink_an ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ