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

ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÏëѧϰoralceµÄ»ù´¡ÖªÊ¶£¬ÏëÎʸ÷λ´óÏÀ£¬ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ,ÎÒ¸öÈËÏëÏÂÔØoracle 10 express°æ£¬ÔõôÑù£¿
±ê×¼°æºÍÆóÒµ°æ¶¼ÐÐ

expressÕâ¸öÊÇʲô°æ±¾£¬ÎÒÔÚoracleÍøÕ¾ÉÏ¿´¸öexpressҪСЩ£¬ËùÒÔÎÒÏëÏÂÔØÕâ¸ö°æ±¾£¬ÔõôÑù£¿

10.2µÄÆóÒµ°æ£¬¶ÔOracleÀ´Ëµ£¬ÓÀÔ¶²»ÒªÏÂÔØexpress°æ¡£


ÏÂÔÚOracle 10g °æ±¾µÄ¡£ ¹ÙÍøÃâ·ÑÏÂÔØ£¬¡°Ãâ·ÑʹÓá±


ÏÂÔØµØÖ·£º
http://www.oracle.com/technology/software/products/database/index.html


------------------------------------------------------------------------------ 
Blog£º http://blog.csdn.net/tianlesoftware 
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net 
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977

ÎÒÒ²ÊÇÐÂÊÖ£¬ÎÒÓõÄÊÇoracle9¡£02£¬¸Ð¾õµ½»¹²»´í

oracle10GµÄ»¹²»´í

Oracle 10.2.0 Express ×Ô¼ºÓÃÓÿÉÒ﵀ ¹ÙÍøÃâ·ÑÌṩÏÂÔØ ×Ô¼ºÒ»Ö±ÔÚÓà ûʲôÎÊÌâ¶øÇÒ°²×°ÎļþС¡¢Õ¼ÄÚ´æÉÙ

10.2.0.1.0 enterprise ¹ÙÍøÏ¡£
¶¼ÊÇÃâ·ÑµÄ¡£
ÄǸöExpress½¨Òé²»ÒªÓ㬸öÈ˾õÐкÍÕýʽµÄ²î±ð²»ÊÇ挻´óµÄ£¬
ÈÝÒ×Ôì³ÉExpressÓûáÁË£¬Ò»µ½ÕýʽµÄ»¹¾³É¶¶¼ÕÒ²»µ½ÁË

express°æÓÐʲô²î±ð£¿

½¨ÒéʹÓÃoracle11g

10g

Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈë¡£ÄÇÎÒ¼ÒÀï×°ÁËvs,ms sql,µçÄÔÅäÖÃÊÇË«ºË£¬1g£¬µ½Ê±°²×°ºó»á²»»áºÜ¿¨£¿¶ÔÁË£¬Äǰ²×°±ê×¼»¹ÊǸöÈ˰æºÏÊÊЩ£¿

ÒýÓÃ

Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈ


Ïà¹ØÎÊ´ð£º

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ