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!

Insert Into table from another table

User_19BPUMar 20 2017 — edited Mar 20 2017

Hi,

I need to insert the records from DB2 table1 to DB1 table1, both the DB tables are same. But from DB1 table1 doesn’t have records, hence I need to insert records into that table1 by fetching the data from DB2 table1. How I can write the Insert Into query from DB1 to achieve this?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2017
Added on Mar 20 2017
7 comments
311 views