oracle OCP¿¼ÊÔºÍÔ³§Åàѵ·ÑÓà - Oracle / ·Ç¼¼ÊõÇø
´ó¼ÒÖªµÀoracle OCP¿¼ÊԵķÑÓÃô£¿
ÎÒÔÚÑÇÍþÅàѵµÃµ½µÄÐÅÏ¢ÊÇ£º
ͨ¹ýOCP¿¼ÊÔÐèÒª-1Z0-043£¬¿¼ÊÔ·ÑÓà RMB 1125£¬´ËÍâ»ñµÃOCPÈÏÖ¤Ê黹ÐèÒªÓÐÒ»ÃÅoracleÔ³§Åàѵͨ¹ýµÄÖ¤Ã÷Êé
²»ÖªµÀ´ó¼ÒÊÇ·ñÖªµÀÕâ¸öoracle Ô³§ÅàѵµÄ·ÑÓôó¸ÅÊǶàÉÙ£¿×îºÃÒѾ»ñµÃOCPÖ¤ÊéµÄÈ˸ø¸ö´ð°¸¡£Ð»Ð»
ÎÒÒ²Ï뿼 ²»Çå³þ Äãgoogle à²à²
µÈ´ýÓйýORACLEÈÏÖ¤µÄÇ°±²ÃǵÄÖ¸µã
ÓÑÇéUp£¡~ Ò²ºÜ¹Ø×¢..
End_rbody_65953204//-->
¸Ã»Ø¸´ÓÚ2010-06-08 08:57:28±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
yuhongpingimu
(ˮľ)
µÈ¡¡¼¶£º
#5Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-06-03 18:24:16
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔص½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......