Urgent :to Copy data between users [message #19650] |
Tue, 02 April 2002 21:18 |
Aparna Venkatraman
Messages: 6 Registered: April 2002
|
Junior Member |
|
|
Hi,
I need to copy a list of tables and their values from one user to another user .The Catch is source and the destination tables will have different field names and width.The copy is for a set of selective fields from the source table to a set of selective fields inthe destincation table.
I tried the copy command,but found it works only when the all the columns of thes table in the destination table are copied.
|
|
|
Re: Urgent :to Copy data between users [message #19660 is a reply to message #19650] |
Wed, 03 April 2002 01:19 |
hanu
Messages: 21 Registered: March 2002
|
Junior Member |
|
|
If those are small tables, you can write query like this:
Insert into dest_table(col1,col2,col3) select col1,col3,col5 from source_table.
Observe that the columns in select and insert are different. This will work.
|
|
|