how to copy and paste entire record between two similar tables in different schemas of same database
Posted on 2009-04-09
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.