ΪʲôÎÒ°ÑwordÎĵµÀïÃæµÄÄÚÈݲåÈëµ½oracleÊý¾Ý¿âÖУ¬¾Í±ä³ÉÁËÂÒÂëÁË£¬ÎÒ¼±Ðè°ïÖú£¬¸÷λ¡£
ÎÊÌâ²¹³ä£ºÎÒÍùÊý¾Ý¿âÀï²åÈëµÄÓдó¶ÔÏ󣬲åÈëµÄÓï¾äÈçÏ£º
insert into ntko_files(id,filename,filesize,filedata) values(2,'82009174128.doc',19968,empty_blob()) £»
ÇëÂ¥Ö÷°ÑÎÊÌâÃèÊöµÄÇåÎúÒ»µã¡£
Oracle ......
±íÃûÊǶ¯Ì¬´«½øÈ¥µÄ£¬ÇëÎÊ¿ÉÒÔ½¨ÕâÑùµÄfunctionÂð£¿
function²ÎÊýΪ±íÃû£¬IDºÍ×Ö¶ÎÃû£»
ÀïÃæÀûÓÃÕâ¸ö±íÃûÆ´Ò»¸öSQLÓï¾äÈ¡³ö¸Ã×ֶεÄÖµÓÃÓαêÖ´Ðн«½á¹ûfetch³öÀ´·µ»Ø¡£
functionÖеÄSQL´®ÊDz»ÊDz»ÄÜÆ´±íÃûºÍ×ֶΣ¬Ö»ÄÜÆ´×ֶεÄÖµ£¿
´ó¼ÒÄܲ»Äܰï°ïÎÒ£¬Ó¦¸ÃÔõôŪ£¬Íò·Ö¸Ðл£¡£¡£¡
SQL code:
create or r ......
±¾À´ÒªÐ´¸ö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 A.id in (select A.id from table_b B)
Ϊɶ´íÎóµÄд·¨£¬oralce±àÒë²»±¨´íÄØ£¿
¶øÇÒ Ö»ÒªB±íÖÐÓÐ ......
Ò»¸öϵͳÖÐÊý¾ÝÁ¿ºÜÅÓ´ó,ËùÒÔ¿¼ÂÇͬÑùµÄÊý¾Ý·ÖºÜ¶àͬÑù±í½á¹¹µÄ±íÀ´´æ·Å(ʵ¼ÊÉÏÒ»ÕűíÒ²Ò»Ñù)
ËùÒÔÔÚÐèÒªµÄʱºò,Òª½«²»Í¬µÄ±íunion/union allÆ´½ÓÔÚÒ»Æð
ÎÊÌâ:¼ÙÈçÏÖÔÚ·Ö10¸ö±í´æ·ÅÊý¾Ý,ÿ¸ö±íÖÐÓÐ1ÍòÊýºÍÿ¸ö±íÓÐ10ÍòÊý¾ÝÔÚÓÃunion allµÄʱºòЧÂʻ᲻»áÓкܴóµÄÇø±ð.
......
oracleÊÇÔõô֪µÀ±ðÈËÓõÁ°æµÄ£¿
ͨ¹ýʲôÇþµÀ×öµ½µÄ£¿
·Ö²»¶à²»ºÃÒâ˼
²»Á˽⣬²»¹ýoracleÒª¼ÓÕâÑùµÄ¹¦ÄÜ£¬Ì«¼òµ¥ÁË¡£
ûÈËÌý˵¹ýÂð£¿
°æÈ¨·¨ÂÉÊֶΰɣ¬ÆäËüÁ˽âÖÐ...
ʹÓÃoracleµÄÓû§£¬ÓÐÊÚȨÊéµÄΪÊÚȨÓû§£¬Ã»ÓÐÊÚȨÊéµÄΪδÊÚȨÓû§£¬Ò²¾ÍÊÇ·Ç·¨Óû§£»
oracleµÄÓªÏú²ßÂÔÖÐûÓÐÕý°æºÍµ ......
ÎÒÔÚ×öÒ»¸öÏîÄ¿µÄ°²×°³ÌÐò£¬ÎªÁ˼ò»¯Ê¹Óã¬ÐèÒªÓôúÂëµÄ·½Ê½´´½¨Ò»¸öOralceµÄÊý¾Ý¿â£¬µ±È»Ç°ÌáÊÇÒѾ°²×°ÁËORACLE¡£
ÎÒÏÖÔÚʹÓõķ½Ê½Êǵ÷ÓÃsqlplusÖ´ÐÐÏàÓ¦µÄ½Å±¾ÊµÏÖ¡£µ«ÎÊÌâÊÇ£¬ÎҵĴúÂëÖв»ºÃÅжϽű¾µÄÖ´Ðнá¹û¡£
ÄÄλ¸ßÊÖ½éÉܵ㷽·¨¡£
Ò²¿ÉÒÔ½«ÄãµÄ½Å±¾µ¼³öΪ¡£dmpºó£¬ÔÙµ¼Èë
½«ÄãËùÓеĽŲ½µ ......