Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Update table attributes from another table

Ramy SFeb 22 2024

Hi,

I am loving oracle syntax (not really). I am unable to update attribute from another table using below.
It doesn't show an error but didn't update "id" field in “MyTable”

Update MyTable a
Set a.ID =
(select b.objid from SourceTable b
where b.DESCRIPTION= trim(a.description)
and a.id =76
)
where a.id =76
commit;

Your help is greatly appreciated

Comments
Post Details
Added on Feb 22 2024
7 comments
156 views