oracleÁ½¸öÊý¾Ý¿âµÄͬ²½£¿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓÃJob ¶¨Ê±Ö´ÐоͿÉÒÔÁË¡£ Á½¸öÊý¾Ý¿â¼äÓÃdblink·ÃÎÊ¡£ ------------------------------------------------------------------------------ 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ÒýÓà ´´½¨Ò»¸ödblinkµ½A, ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£ iihero£¬ ÉýÐÇÁË£¬Òª×£ºØÏ°¡..ÒýÓà ÒýÓà 1 Â¥ iihero µÄ»Ø¸´: ´´½¨Ò»¸ödblinkµ½A, ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£ iihero£¬ ÉýÐÇÁË£¬Òª×£ºØÏ°¡.. ÊǸÃÇì×£Ò»ÏÂÁË£¡ÒýÓà ´´½¨Ò»¸ödblinkµ½A, ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£ ÔõÑù´´½¨dblink£¬job,ʱ¼ä´Á? ÎÒÊǵÚÒ»´Î½Ó´¥µ½oracle£¬Âé·³ÄܾßÌåµãÂ𣿠¥Ö÷£¬Äã°´ÄǼ¸¸ö¹Ø¼ü×ÖÔÙËÑË÷Ò»ÏÂÁË¡£ÄãÈÃÈ˼ҸøÄãд³öÀ´¡£Ä㿽±´Ò»Ï£¬Ï´μûÁËÕÕÑù²»»á¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ 1,2,3,4 ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û 1 2 3 4 ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö??? ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó SQL code: wi ......
oracleº¯ÊýÈçÏ£º create or replace function P_WEB_GETCITYID ( p_mobileNumber in VARCHAR2, p_cityid out NUMBER ) Return NUMBER IS p_areacode varc ......