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
iihero£¬ ÉýÐÇÁË£¬Òª×£ºØÏ°¡..
ÊǸÃÇì×£Ò»ÏÂÁË£¡
ÔõÑù´´½¨dblink£¬job,ʱ¼ä´Á?
ÎÒÊǵÚÒ»´Î½Ó´¥µ½oracle£¬Âé·³ÄܾßÌåµãÂð£¿
Â¥Ö÷£¬Äã°´ÄǼ¸¸ö¹Ø¼ü×ÖÔÙËÑË÷Ò»ÏÂÁË¡£ÄãÈÃÈ˼ҸøÄãд³öÀ´¡£Ä㿽±´Ò»Ï£¬Ï´μûÁËÕÕÑù²»»á¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:
update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......