Update existing columns
Moderators: chulett, rschirm, roy
Update existing columns
Hello
Last edited by kool_cons on Thu Jan 05, 2006 3:01 pm, edited 1 time in total.
It always helps to mention the database involved as that can change the answer given.
That being said, what is your doubt? Based on what you have written it sounds very straight-forward. Select the keys and data from Table A and send them straight to Table B with the action set to 'Update existing rows only'. You may not even need to do a lookup first - Oracle won't complain if an update doesn't actually update any records while another database might. If you need to (or feel like it) hash up the existing keys first.
That being said, what is your doubt? Based on what you have written it sounds very straight-forward. Select the keys and data from Table A and send them straight to Table B with the action set to 'Update existing rows only'. You may not even need to do a lookup first - Oracle won't complain if an update doesn't actually update any records while another database might. If you need to (or feel like it) hash up the existing keys first.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers