Oracle关联update
<div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li><span style="color:#000000;"><span style="color:#0000FF;">create</span> <span style="color:#0000FF;">table</span> t1<span style="color:#0000CC;">(</span><br></span></li><li>id <span style="color:#0000FF;">number</span><span style="color:#0000CC;">,</span><br></li><li>
name<span style="color:#0000FF;">varchar2</span><span style="color:#0000CC;">(</span>10<span style="color:#0000CC;">)</span><br></li><li>
<span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t1 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>1<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'a'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t1 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>2<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'b'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t1 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>3<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'c'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t2 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>1<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">''</span><span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'a1'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t2 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>2<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">''</span><span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'b2'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span><br></li><li>
<span style="color:#0000FF;">insert</span> <span style="color:#0000FF;">into</span> t2 <span style="color:#0000FF;">values</span><span style="color:#0000CC;">(</span>3<span style="color:#0000CC;">,</span><span style="color:#FF00FF;">''</span><span style="color:#0000CC;">,</span><span style="color:#FF00FF;">'c3'</span><span style="color:#0000CC;">)</span><span style="color:#0000CC;">;</span></li><li><span style="color:#0000CC;"><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px; "><p>现在t2表中的name字段要根据t1表中的name更新;</p><p>update t2 set name=(select name from t1 where t1.id=t2.id) where exists (</p><p>select id from t1 where t2.id=t1.id);</p><p><p>select * from t2</p><p>id name loc</p><p>1 a a1<br>2 b b2<br>3 c c3</p></p></span></span></li></ol></div>
页:
[1]