Home » SQL & PL/SQL » SQL & PL/SQL » Urgent :to Copy data between users
Urgent :to Copy data between users [message #19650] Tue, 02 April 2002 21:18 Go to next message
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 Go to previous message
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.
Previous Topic: Re: connecting oracle 8i with d2k
Next Topic: tablespace locally managed
Goto Forum:
  


Current Time: Fri Mar 29 06:30:18 CDT 2024