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

ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿

ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿ÓÐʲô½Ý¾¶Ã»ÓУ¿Çë¸ßÊÖÖ¸µãÃÔ½ò£¬ÔÚ´ËлÁË¡£
ºÇºÇ ûʲô½Ý¾¶ ƽʱ¶à¶à¿´Ê鲢ʵ¼ù°É

ÎÒÒ²ÏëÖªµÀ¡­¡­ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ

¶àдд°É¡£¶à¶¯¶¯ÄÔ¾­

ÒýÓÃ
ÎÒÒ²ÏëÖªµÀ¡­¡­ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ


ºÇºÇ  ¶àÅÜÅÜÓï¾ä°É¡£¡£¡£

×Ô¼º¶à¶¯ÊÖддÁË¡£¡£¡£

ÓÐÒ»±¾SQL 21ÌìµÄÊé¶Ô³õѧÕß°ïÖúºÜ´ó

ÆäʵֻҪ×Ô¼ºÆ½Ê±¶à¶ÁÊé ¶àÇôúÂë
¶à˼¿¼Ë¼¿¼ ¾Í¿ÉÒÔÁË
ÖØÒªµÄÊÇ˼¿¼

"×Ô¼º¶¯ÊÖ,·áÒÂ×ãʳ!"ºÙºÙ£¡


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

ÊÇ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Êý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

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

SQL> select name from v$database;
NAME
---------
ORCL ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ