Solved

how to copy and paste entire record between two similar tables in different schemas of same database

Posted on 2009-04-09
2
501 Views
Last Modified: 2013-12-18
Hi,

I need to export and import( or otherwords copy and paste) entire record between two same structured  tables in different schemas ( say table_A is in schema_A and table_B is in schema_B. Table_B supposed to be same  as Table_A both with structure and data but  couple  of records missing which i need to copy from Table_A and paste into table_B)  of same database. What is the quickest way to do it. Any sample code, ideas, resources highly appreciated. Thanks in advance.
0
Comment
Question by:gudii9
2 Comments
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
ID: 24111479
insert into schema_b.table_b b
select * from schema_a.table_a a
where not exists (select 1 from  a.id = b.id)
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31568734
Thank you very much. I appreciate it.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL Two changes 7 34
Field name with special character (Ñ) in Oracle 11 86
Checking for column width 8 28
update using pipeline function 3 20
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question