ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÏëѧϰoralceµÄ»ù´¡ÖªÊ¶£¬ÏëÎʸ÷λ´óÏÀ£¬ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ,ÎÒ¸öÈËÏëÏÂÔØoracle 10 express°æ£¬ÔõôÑù£¿
±ê×¼°æºÍÆóÒµ°æ¶¼ÐÐ expressÕâ¸öÊÇʲô°æ±¾£¬ÎÒÔÚoracleÍøÕ¾ÉÏ¿´¸öexpressҪСЩ£¬ËùÒÔÎÒÏëÏÂÔØÕâ¸ö°æ±¾£¬ÔõôÑù£¿ 10.2µÄÆóÒµ°æ£¬¶ÔOracleÀ´Ëµ£¬ÓÀÔ¶²»ÒªÏÂÔØexpress°æ¡£ ÏÂÔÚOracle 10g °æ±¾µÄ¡£ ¹ÙÍøÃâ·ÑÏÂÔØ£¬¡°Ãâ·ÑʹÓá± ÏÂÔØµØÖ·£º http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ÎÒÒ²ÊÇÐÂÊÖ£¬ÎÒÓõÄÊÇoracle9¡£02£¬¸Ð¾õµ½»¹²»´í oracle10GµÄ»¹²»´í Oracle 10.2.0 Express ×Ô¼ºÓÃÓÿÉÒ﵀ ¹ÙÍøÃâ·ÑÌṩÏÂÔØ ×Ô¼ºÒ»Ö±ÔÚÓà ûʲôÎÊÌâ¶øÇÒ°²×°ÎļþС¡¢Õ¼ÄÚ´æÉÙ 10.2.0.1.0 enterprise ¹ÙÍøÏ¡£ ¶¼ÊÇÃâ·ÑµÄ¡£ ÄǸöExpress½¨Òé²»ÒªÓ㬸öÈ˾õÐкÍÕýʽµÄ²î±ð²»ÊÇ挻´óµÄ£¬ ÈÝÒ×Ôì³ÉExpressÓûáÁË£¬Ò»µ½ÕýʽµÄ»¹¾³É¶¶¼ÕÒ²»µ½ÁË express°æÓÐʲô²î±ð£¿ ½¨ÒéʹÓÃoracle11g 10g Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈë¡£ÄÇÎÒ¼ÒÀï×°ÁËvs,ms sql,µçÄÔÅäÖÃÊÇË«ºË£¬1g£¬µ½Ê±°²×°ºó»á²»»áºÜ¿¨£¿¶ÔÁË£¬Äǰ²×°±ê×¼»¹ÊǸöÈ˰æºÏÊÊЩ£¿ÒýÓà Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈ
Ïà¹ØÎÊ´ð£º
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
oracleº¯ÊýÈçÏ£º create or replace function P_WEB_GETCITYID ( p_mobileNumber in VARCHAR2, p_cityid out NUMBER ) Return NUMBER IS p_areacode varc ......