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

ÇóORACLE°²×°Îļþ£¬Ð»Ð»°¡

ÇóORACLE°²×°Îļþ£¬Ð»Ð»°¡£¡
xiangziyanhuang@126.com
www.gougou.com
ÎÒ¾ÍÊÇÔÚÕâÀïÏÂÔØ¡£
Õâ¿ÉÊǺܴóµÄ£¬·¢²»¹ýÈ¥µÄ£¡

ºÃ¼¸¸öGÄØ£¬²»ÊÇÍæµÄ

http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html

Èç¹û LZ Ϊ¸öÈË»òСÍÅ¶Ó Ñ§Ï° ʹÓÃ, ¿ÉÒÔÏÂÔØ oracle 10G ±ã½Ý°æ:
http://download.oracle.com/otn/nt/oracle10g/xe/10201/OracleXEUniv.exe

´Ë°æ±¾Ö»ÓÐ 200 ¶à M.°²×°ÍêÓÐ 1G ¶àһЩ
°²×°Íêºó,Ö»ÓÐÒ»¸öÊý¾Ý¿â XE . ½ö½öÖ»ÊÇ Ñ§Ï°ÓÃ

µ±È»À²,¹¦ÄÜÓëÍêÕû°æÍêȫһÑù.Ö»ÊǺܶණÎ÷¶¼ÐèÒª×Ô¼ºÈ¥²Ù×÷,Èç´´½¨ scott Óû§µÈ

Èç¹ûÄãÊÇÔÚÆóÒµ¹¤×÷.ÏëÒª»ñÈ¡ oracle °²×°³ÌÐò,Ó¦¸Ã»¹²»ÖÁÓڻᵽÕâÀïÀ´ÎÊ



ºÙºÙ£¬µÚÒ»»Ø¼ûµ½£¬Òª°ÑOracleµÄ°²×°Îļþ·¢µ½ÓÊÏäÀ£¡ÓÄĬ¡£

ÎÒÕâÀïÓУ¬µ«ÎÒ²»¸ø£¬ºÇºÇ£¬ÌìÖªµÀÒªÉÏ´«¶à¾Ã£¡

È¥¹ÙÍøÏ°¡

lzտţ°¡
Áô¸öÓÊÏ䣬ÎÒ·¢¸øÄ㣬½Óס°¢£¡£¿


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ