| copy column [message #9415] |
Sun, 09 November 2003 07:35  |
Nodocta
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
hi guy's
please i need hepl.
the problem:
i have 2 tables in 2 different db.
the first table in the first db contains the columns: job_num and data_posted.
the second table in the second db contains the columns:job_num, data_posted, worker and adress.
job_num,worker and adress in the second db are allready fill with data.
now i would like to fill the "date_posted" column in the second db with data from the first db so that appropriate date_posted are assign to corresponding job_num as in the first db.
is this possible using the copy command from sql plus? or are there any other tricks a newbie could not know to do this?
please help me it's urgent!!
thanks in advance
|
|
|
|
| Re: copy column [message #9416 is a reply to message #9415] |
Sun, 09 November 2003 21:33  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
First of all u have to create a DBLink which refers to another database and then use:
INSERT INTO TAB1 (SELECT JOB_NUM,DATE_POSTED FROM
TAB2@DBLINK);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
