ÏÂÔØoracleÌØ±ð°æ£¨Í¨Óð棩 - Oracle / »ù´¡ºÍ¹ÜÀí
http://www.oracle.com/technology/global/cn/software/products/database/xe/htdocs/102xewinsoft.html
ÊÇÔÚÕâ¸öÁ´½ÓÏÂÔØÂð£¬ÈçÏ£º
Oracle Êý¾Ý¿â 10g ÌØ±ð°æ£¨Í¨Óð棩
OracleXEUniv.exe£¨216,933,372 ×Ö½Ú£©
Õë¶ÔËùÓÐÓïÑÔ²¿ÊðµÄ¶à×Ö½Ú Unicode Êý¾Ý¿â£¬¸ÃÊý¾Ý¿âÖ÷Ò³µÄÓû§½çÃæ¿ÉÒÔʹÓÃÒÔÏÂÓïÑÔÏÔʾ£º°ÍÎ÷ÆÏÌÑÑÀÎÄ¡¢ÖÐÎÄ£¨¼òÌåºÍ·±Ì壩¡¢Ó¢ÎÄ¡¢·¨ÎÄ¡¢µÂÎÄ¡¢Òâ´óÀûÎÄ¡¢ÈÕÎÄ¡¢º«ÎĺÍÎ÷°àÑÀÎÄ¡£
¸Õ¸Õ½Ó´¥oracle£¬Ïë°²×°ÔÚwin7Ï£¬Õâ¸ö°æ±¾¿ÉÒÔÂð£¬Ð»Ð»£¡
Ö÷ÒªÓÃÁ˳õ¼¶Ñ§Ï°and²âÊÔ¡£¡£¡£
·Ç³£¸Ðл¡£ºÇºÇ¡£
´ËÁ´½Ó£ºhttp://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html
32λµÄ10.2.0.3/£¬Ã²ËÆ»¹ÒªÏÂÔØ°²×°10.2.0.4²¹¶¡¡£OK¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......