Çó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տţ°¡
Áô¸öÓÊÏ䣬ÎÒ·¢¸øÄ㣬½Óס°¢£¡£¿
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
±¾À´ÒªÐ´¸ö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£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......