ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿
ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿ÓÐʲô½Ý¾¶Ã»ÓУ¿Çë¸ßÊÖÖ¸µãÃÔ½ò£¬ÔÚ´ËлÁË¡£
ºÇºÇ ûʲô½Ý¾¶ ƽʱ¶à¶à¿´Ê鲢ʵ¼ù°É
ÎÒÒ²ÏëÖªµÀ¡¡ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ
¶àдд°É¡£¶à¶¯¶¯ÄÔ¾
ºÇºÇ ¶àÅÜÅÜÓï¾ä°É¡£¡£¡£
×Ô¼º¶à¶¯ÊÖддÁË¡£¡£¡£
ÓÐÒ»±¾SQL 21ÌìµÄÊé¶Ô³õѧÕß°ïÖúºÜ´ó
ÆäʵֻҪ×Ô¼ºÆ½Ê±¶à¶ÁÊé ¶àÇôúÂë
¶à˼¿¼Ë¼¿¼ ¾Í¿ÉÒÔÁË
ÖØÒªµÄÊÇ˼¿¼
"×Ô¼º¶¯ÊÖ,·áÒÂ×ãʳ!"ºÙºÙ£¡
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
±¾À´ÒªÐ´¸ö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 ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......