Skip to Main Content

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!

Copy column data from backup table

User_K8JYRDec 23 2022

Hi,
I have two tables t1 and t2. t2 is the backup of t1. There is no primary key column in these tables. Table has col1 and col2 columns. col1 is corrupted I want to copy it from t2. How can I do the data copy using update statement?

Comments
Post Details
Added on Dec 23 2022
3 comments
458 views