Update Oracle table data from data in Excel file [message #284148] |
Thu, 29 November 2007 00:54 |
yogeshyl
Messages: 50 Registered: October 2007 Location: Silvassa
|
Member |
|
|
Hello Experts,
I want to update the oracle table data from excel file(.xls). The excel file & table format is same. Actually the excel file is taken from the previous backup of database of the same table.
Now when i try to update the table data by using "import table data" option in toad, only a few records gets updated. It gives some errors like unique constraints violated.
Is there any alternative method to update the table data. The excel file is having near about 18000 records.
Yogesh
[MERGED by LF]
[Updated on: Thu, 29 November 2007 05:23] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: Update Oracle table data from data in excel file [message #284231 is a reply to message #284214] |
Thu, 29 November 2007 03:36 |
yogeshyl
Messages: 50 Registered: October 2007 Location: Silvassa
|
Member |
|
|
After converting to csv format what will be the sql query if suppose my table name is OM_QC_PARAMTETERS and the field names are QCP_QC_CODE,QCP_PARA_CODE,QCP_USL,QCP_LSL.
I want to change the last two fields/ columns data i.e QCP_USL & QCP_LSL where QCP_PARA_CODE='pH10%' AND QCP_QC_CODE='AAAAAA'
For each QCP_PARA_CODE and QCP_QC_CODE i want to change the QCP_USL & QCP_LSL
Please guide me on this.
|
|
|
|