Oracle³õѧÕßµÄÎÊÌ⣡£¡£¡£¡£¡
ÎÒÊÇwin7ϵͳ£¬sql server 2008Óе㲻¼æÈÝ£¬¾Í»»oracle 11gÊÔÊÔ£¬ÒÑÍê³É°²×°¡£µ«Òò¸Õ½Ó´¥²»»áʹÓ㬳öÏÖÈçͼÁ½ÖÖÎÊÌ⣬µÚÒ»¸öÒ»´ò¿ªSQL Developer¾Í³öÏÖÕâ¸ö£¬µÚ¶þºÜÃ÷ÏÔÊÇSQl plusÁË¡£°ïæָµãһϣ¬ÏÈл¹ýÁË£¡£¡£¡
»¹ÓУ¬ÍƼöÒ»ÏÂѧOracleµÄÍøÕ¾»òÕßÎÄÕ£¬ÊéÒ²ÐС£
http://hi.csdn.net/attachment/200912/11/76719_1260492159tLdk.jpg
http://hi.csdn.net/attachment/200912/11/76719_1260492159kF5C.jpg
1:WIN 7 ÏÂÅäÖÃÏÂJAVA»·¾³±äÁ¿
ͼƬÉÏÏÔʾµÄÊǵ¼ÈëJava ·¾¶£¬Â¥Ö÷Ò²¿ÉÒÔÓÃÆäËûµÄ¹¤¾ß£¬ÈçToad£¬ ¹ÜÀíÉÏ»¹ÊDZȽϷ½±ãµÄ¡£
------------------------------------------------------------------------------
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
ÎҵĵçÄÔ——ÊôÐÔ——¸ß¼¶——»·¾³±äÁ¿——ÅäÖÃJAVA»·¾³±äÁ¿
oracle°²×°Ò»°ã×Ô¼º´øjavaµÄ ¿ÉÄÜoracle 11g ÓÐËù±ä¶¯ÁË
Õâ¸öÊÇ »·¾³±äÁ¿µÄÅäÖà http://blog.163.com/genyou_nwpu/blog/static/9381585320088126658469/
Â¥Ö÷¿ÉÒÔÓÃÏÂPlsql developer×÷Ϊ¿ª·¢¹¤¾ß
Ñ§Ï°ÍøÕ¾£ºwww.mldn.cn
ÄãEÎļþºÃµÄ»°½¨Òé¿´ ¹ÜÍøµÄ£ºÁª»úÎĵµ£¬É¶¶¼ÓÐ
http://www.oracle.com/technology/documentation/index.html
ORACLE¹Ù·½Áª»úÎĵµ
mark
Ò»¿´¾ÍÊÇûÓнø¹ý¹«Ë¾µÄÈË£¡Ï²»¶ÓÃ×îа汾¸Éʲô£¿
Õâ¸ö˵Ã÷ÒªÖ¸¶¨JDK£¬Ê×ÏÈ£º
°²×°JDK£¬±ÈÈç°²
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
±¾À´ÒªÐ´¸ö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Êý¾Ý¿âµ¼³ö±í¸ñ£¬´æ´¢¹ý³Ì£¬ÒÔ¼°µ¼³ö´¥·¢Æ÷Ö®ÀàµÄ·½·¨¡£
ÒÔ¼°µ¼Èë¡£¡£¡£
Õâô˵°É£¬¾ÍÊÇoracle 10µÄÊý¾Ý¿âÇ¨ÒÆ¡£¡£¡£
·Ç³£¸Ðл
Ò²¾ÍÊÇ£¬ÎÒÔÚÒ»¸ö»úÆ÷ÉÏÓÐÁËÊý¾Ý¿â£¬Òª°ÑÕâ¸öÊý¾Ý¿â×ªÒÆµ½ÁíÍâÒ»¸ö° ......