Éý¼¶oracleÖеÄJDK°æ±¾
Oracle×Ô8iÆð¾ÍÈ«ÃæÖ§³Öjava£¬µ«¸÷¸ö°æ±¾µÄoracleÖÐĬÈÏjdk°æ±¾¾ù²»Ïàͬ£¬oracle8iÖÐΪ jdk1.2,oracle9iÖÐΪjdk1.3,oracle10gÖÐΪjdk1.4~~ÖÁ±ÊÕßÐÐΪ֮¼Ê£¬µ±Ç°µÄ×îа汾Ϊjdk1.5 update 11.
Òò±ÊÕßjava¿ª·¢³öÉí£¬ÔÚ×öoracle¿ª·¢Öо³£»áÓÃjavaÀ´À©Õ¹ oracle¹¦ÄÜ£¬µ«ÊÇÓÉÓÚoracle×Ô´øjdk°æ±¾¹ýµÍ£¬¿ÉÄÜ»áÔì³ÉһЩjava source±àÒëÎÞ·¨Í¨¹ý£¬ÓÚÊÇ°³ÏëÉý¼¶oracleÖеÄjdk£¬¾¹ý¸÷´óËÑË÷ÒýÇæËÑË÷£¬·¢ÏÖÏà¹ØÐÐÎÄÉõÉÙ£¬²¢ÇÒ¶¼²»ÍêÕû¡£±ÊÕß¾¹ýÒ»·¬Ñо¿£¬³É¹¦Éý¼¶£¬ÏÖ½«¹ý³Ìд³ö£¬¹©ÓÐÐÄÈ˲ο¼¡£
ITPUB¸öÈË¿Õ¼ä6B@ in1@)L.v,L J ?
ÒÔwindowsƽ̨ΪÀý¡£
Ê×ÏÈÐèÒªÏÂÔØ×îа汾µÄjdk£¬ÍƼöÖ±½Óµ½¹ÙÍøÏÂÔØ£¬µØÖ·ÈçÏ£º
https://sdlc3e.sun.com/ECom/EComActionServlet;jsessionid=CAB346E4103EE6D4FAE5F9B12FB3D928
ÏÂÔØÍê³ÉÖ®ºó£¬°´ÕÕ˵Ã÷°²×°£¬Ò»°ãÖ»ÐèÒªµã»÷next¼´¿É¡£¹ý³ÌÖлáÌṩÄãÑ¡ÔñjdkºÍjreµÄ°²×°Î»Ö㬿ÉÒÔĬÈÏÒ²¿ÉÒÔ×Ô¼ºÉ趨°²×°Ä¿Â¼£¬´ËĿ¼ÐèÒª¼ÇÒ䣬°²×°ÍêÖ®ºóÉ趨java_homeµÈ»·¾³±äÁ¿Ê±ÐèÒªÓõ½¡£±¾ÀýÖÐΪc:program filesjavajdk150,c:program filesjavajre150
°²×°Íê³ÉÖ®ºó´ò¿ª×ÀÃ棬ÓÒ¼üÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿
ÔÚϵͳ±äÁ¿ÖÐÉ趨н¨£¬ITPUB¸öÈË¿Õ¼ä:Pjemma`
±äÁ¿Ãû£ºJAVA_HOME£¬±äÁ¿ÖµÎªjdk°²×°Ä¿Â¼c:program filesjavajdk150¡£
dBi,Vh3o7590422È·¶¨ºóÔÙн¨£¬ITPUB¸öÈË¿Õ¼ä(Ok3p?8[ J5_a-s
±äÁ¿Ãû£ºJRE_HOME,±äÁ¿ÖµÎª£ºc:program filesjavajre150.ITPUB¸öÈË¿Õ¼ä.h�c'd5X*TcNIF
È·¶¨ºóн¨£¬ITPUB¸öÈË¿Õ¼ä:s!vy+h'KR qd
±äÁ¿Ãû£ºCLASSPATH,±äÁ¿Öµ£º.;
È»ºóÉ趨path,oracle°²×°ºó»á×Ô¶¯½«ÆäĬÈϵÄjre·¾¶Ð´Èëpath±äÁ¿£¬Äã¿ÉÒÔ½«oracleÉ趨µÄjre·¾¶¸Ä³ÉÄã¸Õ¸Õ°²×°µÄз¾¶£¬Ò²¿ÉÒÔÖ±½Ó½«ÐµÄjdk·¾¶Ð´ÔÚ×îÇ°£¬×ÜÖ®¾ÍÊÇÈÃjava sources±àÒëµÄʱºòÒªÄܹ»ÕÒµ½Ð°汾µÄjdkËùÔÚ.
È«²¿Íê³ÉÖ®ºóÔÚcmd´°¿Újava -version£¬Èç¹ûÏÔʾjava version "1.5.0_xx"ÔòÉý¼¶³É¹¦¡£Èç¹ûÓÐÎ󣬼ì²éÒ»ÏÂÊÇ·ñÇ°ÃæµÄ²½ÖèÓвÙ×÷ʧÎóµÄµØÖ·£¬ÖØвÙ×÷¼´¿É¡£
Ïà¹ØÎĵµ£º
declare
msg varchar(1000); --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg); --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg); --Êä³ö±äÁ¿
end; ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......
µ¼¶Á£º
¡¡¡¡2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ ......
Case¾ßÓÐÁ½ÖÖ¸ñʽ¡£¼òµ¥Caseº¯ÊýºÍCaseËÑË÷º¯Êý¡£
--¼òµ¥Caseº¯Êý
CASE sex
WHEN '1' THEN 'ÄÐ'
WHEN '2' THEN 'Å®'
ELSE 'ÆäËû' END
--CaseËÑË÷º¯Êý
CASE WHEN sex = '1' THEN 'ÄÐ'
WHEN sex = '2' THEN 'Å®'
ELSE 'ÆäËû' END
ÕâÁ½ÖÖ·½Ê½£¬¿ÉÒÔʵÏÖÏàͬµÄ¹¦ÄÜ¡£¼òµ¥Caseº¯ÊýµÄд·¨Ïà¶Ô±È½Ï¼ò½à ......