Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬µ½Ê±°²×°ºó»á²»»áºÜ¿¨£¿¶ÔÁË£¬Äǰ²×°±ê×¼»¹ÊǸöÈ˰æºÏÊÊЩ£¿

ÒýÓÃ

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


Ïà¹ØÎÊ´ð£º

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

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

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......

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 ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ