[ת]Oracle ¹«²¼ Java ·¢Õ¹²ßÂÔ
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄHotSpotºÍBeaµÄJRockit¶¼ÊDzßÂÔÐÔÐéÄâ»ú£ºÈÚºÏÁ½ÕßµÄ×î¼ÑÌØÐÔ£¬Ìṩ¹ÜÀíºÍʵʱ¼à¿Ø¹¦ÄÜ£¬ÔÚhypervisorÕâ²ãÖÐÔËÐÐ ±¾µØÐéÄâ»ú´úÂ룬֧³Ö¶àºËCPU NUMA¼Ü¹¹µÄ±àÒëÓÅ»¯µÈ¡£
3) ¼ÌÐøÖ§³Ö¶àÖÖ²Ù×÷ϵͳƽ̨¡£
Java EE:
1£©¼ÌÐø·¢Õ¹Java EEµÄ²Î¿¼ÊµÏÖ£¨RI,reference implementation), ½øÒ»²½¶ÔÄ³Ð©ÖØÒªµÄ·½Ïò£¬È翪·Å±ê×¼µÄÄ£¿é»¯£¬ÐµÄÇáÁ¿¼¶·þÎñÆ÷ÅäÖã¬RIAºÍÓû§½çÃæ£¬½Å±¾ºÍ¶¯Ì¬ÓïÑÔÒÔ¼°Web ServicesµÈ¡£
2£©Glassfish¿ªÔ´Ó¦Ó÷þÎñÆ÷½«¼ÌÐø×÷ΪJava EEµÄRI£¬Weblogic½«¼ÌÐø×÷ΪÆóÒµ¼¶µÄÓ¦Ó÷þÎñÆ÷¡£
3) GlassFish½«¼ÌÐø±£³ÖÏÖÓеķ¢²¼·½Ê½¡£
Java ME:
1)ͳһµÄJavaMEºÍJava SEµÄAPI¡£
2)ÓÅ»¯Java ME£¬°üÀ¨Æô¶¯ºÍÔËÐеÄÐÔÄÜ£¬ÐµÄÓû§½»»¥Ä£Ê½£¬ÄÜÔ´ÏûºÄÓÅ»¯£¬¶ÔjavaFX MobileµÄÓÅ»¯£¬ÒÆÖ²µ½IP TV,blue RayºÍÆäËûǶÈëÉ豸¡£
3) ±£³Ö¶ÔÔËÓªÉ̺ÍÉ豸³§¼ÒµÄ¶þ½øÖÆÓÅ»¯¡£
javaFX ¸»»¥ÁªÍøÓ¦ÓÃ(Rich Internet Applications)
1£©Í¨¹ýÀ©Õ¹Java¹¦ÄÜÀ´ÌṩǰËùδÓеÄRIAÌåÑ飻
2£©ÃæÏò£¨½çÃæ£©Éè¼ÆµÄ¿ÉÊÓ»¯×é×°£»
3) ¸ßЧµÄUI×é¼þ¿â£»
4£©¿çÉ豸µÄ¿ÉÒÆÖ²ÐÔºÍÓû§½»»¥Ä£ÐÍ£¬°üÀ¨Òƶ¯¡¢×ÀÃæ¡¢µçÊÓÒÔ¼°ÆäËûÉ豸¡£
5£©ÊµÏÖÎÞ·ìµÄÓëjava, javascript ÒÔ¼°html 5µÄ»¥²Ù×÷ÐÔ¡£
6£©²¹³äOracle ADF/ADF MobileµÄ¹¦ÄÜ¡£
Java¿ª·¢¹¤¾ß
1£©SunµÄNetBeans¼ÌÐø×÷ΪÇáÁ¿¼¶µÄJava IDE, ÖØµãÔÚJava EE6£¬Java MEºÍ½Å±¾ÓïÑÔ£¬Ôö¼ÓÔÚÒÆ¶¯Ó¦ÓúͶ¯Ì¬½Å±¾ÓïÑԵĹØ×¢£¬Hudson½«×÷Ϊ¿ªÔ´µÄBuild·½°¸¡£
2£©¼×¹ÇÎĵÄJDeveloper½«¼ÌÐø³ÉΪOracleµÄ²ßÂÔÐԵĿª·¢¹¤¾ß£¬Ö÷Òª×÷ÓÃÊǺÍfusionµÈÖмä¼þµÄ¼¯³É¡£
3) ¼ÌÐø¶ÔEclipse iDEµÄÖ§³ÖºÍ×÷¹±Ïס£
Ïà¹ØÎĵµ£º
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from d ......
¡¾°¸ÀýÒ»¡¿
ÌâÄ¿£º
--´¥·¢Æ÷£º
--Ìí¼ÓÔ±¹¤ÐÅÏ¢,Á÷Ë®ºÅ×÷Ϊ×Ô¶¯±àºÅ(ͨ¹ýÐòÁÐÉú³É),
--²¢ÇÒÅжÏÈç¹û¹¤×ÊСÓÚ0,Ôò¸ÄΪ0;Èç¹û´óÓÚ10000,Ôò¸ÄΪ10000¡£
CREATE TABLE emp2(
e_id NUMBER,
e_no NUMBER,
e_name VARCHAR2(20),
e_sal NUMBER
)
SELECT * from emp2;
CREATE SEQUENCE seq_trg_id;
INSERT INTO emp2(e_i ......
ÕÒ²»µ½ÔÌûÁË ¾ÍÌùÕâÀï°É£¡
ÔÚÏò´ó¼ÒÏêϸ½éÉÜOracle֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂOracle xmltypeÊÇʲô£¬Oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ----
xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃæ½«½éÉÜOracle
xmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐOracle xmltypeÊý¾Ý ......
¾²âÊÔ£¬ÔÚOracleÖУ¬¶ÔÓÚnullºÍ¿Õ×Ö·û´®'',webMethods JDBC Adapter ²éѯ³öÀ´¶¼»áÏÔʾnull.
¶øÔÚSQL SERVERÖУ¬»á·Ö±ðÏÖʵΪnullºÍ¿Õ×Ö·û´®¡£
º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ ......
µÚÒ»ÕÂ. JAVAÌåϵ½á¹¹½éÉÜ
µÚÒ»½Ú ΪºÎʹÓÃJava:ƽ̨Î޹أ¬°²È«£¬ÍøÂçÒÆ¶¯ÐÔ
µÚ¶þ½Ú Ìåϵ½á¹¹
1.
JAVAÐéÄâ»úµÄ»ù±¾½á¹¹Í¼£º
2. & ......