I would like to know how do you update over 1000 rows in the EMP table from the creating a temp table from the EMP table where you are updating the column name Last_name? Lets say that there are 4000 rows in the EMP table. I create a temp table from emp and I have a excel spread sheet with 1000 new Last names that need to be updated in the EMP table for each row. So the spreadsheet would have ID and Last_name on it so those 1000 ID's will have new last names assigned to it when I load it into the EMP_TEMP table. I have read different posts saying I could use the MERGE statement or use the UPDATE statement but I am not sure on how to write the query so there will be 1000 updated names in the EMP table from the EMP_TEMP table or which statemnt would work the best. I am using Oracle 11g Release 2. If you could provide an example of the a query for the MERGE statment and UPDATE statement I would appreciate much.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.