Skip to Main Content

SQL & PL/SQL

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
128 views