serverÓïÑÔת³ÉoracleÓïÑÔ - Oracle / ¿ª·¢
Çë¶®µÄ°ïæת»»Ï¡£¡£¡£¡£Ð»Ð»ÁË¡£¡£
//ÓÃÓÚ·ÀÖ¹Èճ̱êÌⳤ¶È³¬¹ýÊý¾Ý¿âÖÐÈճ̱êÌâ×ֶεÄ×î´ó³¤¶È£¬Èç¹û³¬¹ý£¬½ØÈ¡ÔÊÐíµÄ×î´ó³¤¶ÈÊýÁ¿µÄ×Ö·û×÷Ϊ±êÌâ
public void CheckTitle()
{
Title.Trim();
if (Title.Length>=MaxTitleLength)
{
Title=Title.SubString(0,MaxTitleLength);
}
}
ÔΣ¬·¢´íÁË¡£¡£
{{
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
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 ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......