ÏÂÔØ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£¬µ½Ê±°²×°ºó»á²»»áºÜ¿¨£¿¶ÔÁË£¬Äǰ²×°±ê×¼»¹ÊǸöÈ˰æºÏÊÊЩ£¿ÒýÓà Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
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 ......