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!

update column based on another column

548849Oct 7 2008 — edited Oct 8 2008
Hi All,

I want to update column 2 in table A based on the update value in Column 1 and existing value in Column 1

suppose table1 has columns ID, col1 and col2

i want to update col2 based on value updated to col1 and comparing the existing value of col1 in table.

trying out decode, i think it should work.

Thanks.
This post has been answered by jeneesh on Oct 8 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2008
Added on Oct 7 2008
15 comments
4,648 views