Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÏÂÔØ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¡£¡£


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - 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 ......

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ