<div>
UPDATE table SET product_key = product_key || location_code;
</div>


UPDATE table SET product_key = product_key || location_code;

<div>
Sorry, use this : UPDATE table SET product_key = product_no || location_code;<br />
Make sure that product_key is a CHAR / VARCHAR field and not a purely NUMERIC field.
</div>


Sorry, use this : UPDATE table SET product_key = product_no || location_code;
Make sure that product_key is a CHAR / VARCHAR field and not a purely NUMERIC field.

<div>
<div class="content wysiwyg-content">
hi currently i have a table with columns &nbsp;and data's like this<br />
product_key &nbsp; &nbsp; &nbsp; &nbsp;product_no &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;location_code<br />
<br />
11223 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11223 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LSB<br />
<br />
but i want to update the product_key data's to be 11223-LSB . could you please send me the pl/sql query to update . there are some 384 records with the wrong data . &nbsp;i tried like this<br />
<br />
update table set product_key=replace(produc<wbr />t_key,prod<wbr />uct_no,'-L<wbr />SB') &nbsp;<br />
<br />
but its updating the product_key as just -LSB not with the numbers. please give me a solution<br />

</div>
</div>


hi currently i have a table with columns  and data's like this
product_key        product_no              location_code

11223                  11223                        LSB

but i want to update the product_key data's to be 11223-LSB . could you please send me the pl/sql query to update . there are some 384 records with the wrong data .  i tried like this

update table set product_key=replace(product_key,product_no,'-LSB')  

but its updating the product_key as just -LSB not with the numbers. please give me a solution


Pl/SQL query---

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.