maximus1974

<div>
<div class="content wysiwyg-content fr-view">
Need to update OPERATION_BOM.UNIT_PRICE with the values in PARTS_MASTER.LIST_PRICE joining by PNM_AUTO_KEY. <br><br>These are the two tables:<br>OPERATION_BOM<br>PARTS_MASTER
</div>
</div>



Need to update OPERATION_BOM.UNIT_PRICE with the values in PARTS_MASTER.LIST_PRICE joining by PNM_AUTO_KEY.
These are the two tables:
OPERATION_BOM
PARTS_MASTER

How can I join two tables in an Oracle update statement

Oracle PL/SQL

oracle syntax

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.