Oracle database table backup and table recovery how to update multiple fields in one table of Oracle to another table

For simpler tables, the amount of data is not a very much table, you can use a simple SQL statement to back up


CREATE TABLE t_fa_cat_20121207 as SELECT * from T_fa_cat
Create a new table and save the data

INSERT INTO T_fa_cat select * from t_fa_cat_20121207

To import the original backed-up data into a table to recover data

How to update multiple fields in a table on Oracle to another table
Update a set (a.province,a.city) = (select province,city from B where b.mobile=a.mobile)

How to update a single field in an Oracle table to another table

Update a set a.province = (Select province from B where B.mobile=a.mobile)