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 data into table from another table in different DB connection

S567Jun 25 2018 — edited Jun 25 2018

Hi team,

I have two tables A and B and both have same structure.

B is the table i created in X databse connection.

Now i want to move the data in B data to A table.

A is defined is another databse connection.

How can i achive this using INSERT statement.

Thanks,

Shiva
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2018
Added on Jun 25 2018
7 comments
4,490 views