Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Update a table having same id but different data in rows?

AS08Oct 10 2021

Suppose I have a table t1 having same id with following data
ID | Name | Applciation_id | Location
1 | UAT | 123 | USA
1 | TEST | 222 | UK
Now I want to only update name column of the 1st row only(below is the desired o/p)
ID | Name | Applciation_id | Location
1 | DEV | 1 23 | USA
1 | TEST | 222 | UK
This post has been answered by mathguy on Oct 10 2021
Jump to Answer

Comments

Post Details

Added on Oct 10 2021
#plsql, #sqldeveloper
4 comments
3,387 views
2 mentions