<div>
Hello,<br><br>the general syntax would be like this...<br>Update TableName <br>Set ColumName = Value<br>Where ....<br><br>The where clause is the same than in the select statement.&nbsp;
</div>


Hello,

the general syntax would be like this...
Update TableName
Set ColumName = Value
Where ....

The where clause is the same than in the select statement. 

<div>
i know general syntax<br>DM &nbsp;= usr_usrgrp_code
</div>


i know general syntax
DM  = usr_usrgrp_code

<div>
Can you provide some sample data with expected result? That would be easy for anyone to play around with the data to write the query.
</div>


Can you provide some sample data with expected result? That would be easy for anyone to play around with the data to write the query.

noc_item_usrgrp134.txt

NOC_ITEM_USRGRP.txt

<div>
<div class="content wysiwyg-content fr-view">
hi i what to update records for following conditions<br><br>Extract all records where DM is 17 and all parts linked to the NSNs and all users linked.<br><br>If 17 is the only user and DM - change 17 to 05.<br>If 05 is a user - change DM 17 to 05 and delete user 05<br>If 05 is not a user - change DM to 05<br><br>Only the IUG_SEQ will change IF THE IUG = 1 FOR 17.<br><br><br>Only when the IUG_SEQ = 1 FOR 17 THEN IT WILL CHANGE TO 2, 3 , 4 OR 5<br>THEN THE IUG_SEQ WILL BE 1 FOR 05<br><br><br>this the table<br>NOC_ITEM_USRGRP<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559525/update23.jpg" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559525/update23.jpg" class="fr-fic fr-dib"></a><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559526/usrgrp0994.jpg" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559526/usrgrp0994.jpg" class="fr-fic fr-dib"></a>
</div>
</div>


usrgrp0994.jpg

update23.jpg


hi i what to update records for following conditions
Extract all records where DM is 17 and all parts linked to the NSNs and all users linked.
If 17 is the only user and DM - change 17 to 05.
If 05 is a user - change DM 17 to 05 and delete user 05
If 05 is not a user - change DM to 05
Only the IUG_SEQ will change IF THE IUG = 1 FOR 17.
Only when the IUG_SEQ = 1 FOR 17 THEN IT WILL CHANGE TO 2, 3 , 4 OR 5
THEN THE IUG_SEQ WILL BE 1 FOR 05
this the table
NOC_ITEM_USRGRP

update records for the following conditions

Oracle12c

Oracle PL/SQL

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.