½«OracleµÄÊý¾Ýµ¼Èëµ½MDBÖгöÏÖ´íÎó - Oracle / ¿ª·¢
ÎÒÔÚ³ÌÐòÖн«oracleÊý¾Ý¿âµÄ¶«Î÷select³öÀ´ ÔÙ²åÈëµ½MDBÖÐ £¬È»ºóÔÙMDBÖв鿴µÄʱºò·¢ÏÖÓкܶà×Ö¶ÎÖµ¶¼Ëð»µÁËÎÞ·¨ÏÔʾ£¬ÔÚµ¼³ö¹ý³ÌÖÐûÓгöÏÖ´íÎ󣬲»ÖªµÀÊÇʲôÔÒòÔì³ÉµÄ°¡£¿
ÀàÐÍ¿ÉÊÇÒ»Öµģ¿
ÀàÐÍÒ»Ö£¬¶¼ÊÇ×Ö·ûµÄ
×Ô¼º¶¥£¡
ÔÙ¶¥£¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......