oracle 11g ¹Ù·½ÏÂÔØ²»ÁË£¬ÎªÊ²Ã´£¿
ÏÂÔØµÄÊÇLinux°æ±¾µÄ
Ã÷Ã÷ÒѾ¡°welcome XX¡±ÁË£¬µã»÷ÏÂÔØ»¹ÊÇÒª¡°µÇ½¡±
¶øÇҵǽ²»ÉÏ£¬ÃÜÂëûÓÐÎÊÌâ¡£
ÓÃѸÀ×£¬²»ÓõǼ£¬Ö±½ÓÏÂÔØ¡£
Ë¢ÐÂһϣ¬ ÏÂÔØÖ®Ç°»¹Óиöµ¥Ñ¡°´Å¥£¬±ØÐëµãͬÒâÖ®ºó²ÅÄÜÏÂÔØ¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
Ï£Íû¸÷λ¸øÔÚϵãµãÊÔÊÔ¿´ÓÐûÓÐËÙ¶È£¬·´ÕýÎÒÕâ¶ùÊÇÒ»µã¶ù¶¼Ã»ÓеÄ
ÏÂÔØ£ºlinux.x64_11gR2_database_2of2.zip
µØÖ·£ºhttp://www.oracle.com/technology/software/products/database/oracle11g/112010_linx8664soft.html
ÓÐʱ»áÕâÑùµÄ£¬²»¹ýÄãµÃ¿´¿´ÄãµÄÍøÂ磬Á¬½ÓORACLE¹ÙÍøÊÇ·ñÕý³£¡£
ÎÒÉÏ´ÎÏÂ10gÒ²ÕâÑù£¬Ñ¸À×ÀÏÌáʾÎÞ·¨ÏÂÔØ£¬ÕÒ²»µ½×ÊÔ´¡£
ÍøÂçûÎÊÌâ°¡£¬ÏÂÔØÆäËûµÄ¶«Î÷¶¼ì¬ì¬µÄ~~
???£¬50¼¸K£¬ÏÂÁË2M£¬Í£ÁË¡£¡£¡£
ÎҵľÍÁ¬ 1k ¶¼Ã»ÓУ¬Ò»»á¶ùÔÙ¿´³ÉXÁË£¬²»ÄÜÏÂÔØÁË
ºÍÎÒǰ¼¸ÌìÒ»Ñù¡£ÕÒ¸öÍøÂ糩ͨµÄʱºòÏ¡£
ÄãÁ¬½Ó¹úÄÚÍøÕ¾Ë³³©£¬Äã´ò¿ªORACLEÖ÷ҳ˳³©£¬²»Ò»¶¨´ú±íÄãÏÂÔØÒ»¶¨Õý³££¡
È·±£ÄãµÄ×¢²á³É¹¦µÄǰÌáÏÂ
http://www.oracle.com/technology/global/cn/software/products/database/index.html
½øÕâ¸öÍøÕ¾Ïµķdz£ºÃ¡£
ÎÒϵÄʱºòºÃ¿ìµÄ°¡
´ïµ½7M£¬¼¸Ê®Ãë¾ÍOKÁË
¿
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......