<div>
udpate clc<br />
set pukk = (select puk1 from puk where puk.imsi_no =cls.imsi_no)
</div>


udpate clc
set pukk = (select puk1 from puk where puk.imsi_no =cls.imsi_no)

<div>
typo<br />
<br />
update<br />
<br />
not<br />
<br />
udpate
</div>


<div>
try this.<br />

<pre><code id="code-7988062">UPDATE CLC c 
   SET c.PUKK = (SELECT p.PUK1 
                   FROM PUK p 
                  WHERE c.IMSI_NO = p.IMSI_NO)</code></pre>
</div>


try this.


UPDATE CLC c 
   SET c.PUKK = (SELECT p.PUK1 
                   FROM PUK p 
                  WHERE c.IMSI_NO = p.IMSI_NO)

<div>
didn't see sdstuber's post.
</div>


<div>
<a href="http:#34973172" rel="ugc">http:#34973172</a> &nbsp;should have been accepted since it was first<br />
<br />

</div>


http:#34973172 [http:#34973172]  should have been accepted since it was first



<div>
<div class="content wysiwyg-content">
I have two tables Table CLC(IMSI_NO,PUKK) and TABLE PUK(IMSI_NO , PUK1).<br />
<br />
Need to update table CLC with PUk1 valueof Table PUK for values matching IMSI_NO in CLC and PUK 
</div>
</div>


I have two tables Table CLC(IMSI_NO,PUKK) and TABLE PUK(IMSI_NO , PUK1).

Need to update table CLC with PUk1 valueof Table PUK for values matching IMSI_NO in CLC and PUK 

Update Query Required

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.