Data doesnt get updated using Data Load Wizard
yomanSep 2 2012 — edited Sep 30 2012Hi,
I am using
Oracle DB XE 11
Apex 4.1
I have created a data load wizard on a table "price list" with structure as below
id number
vid number
itemid number
price number
When I try to enter data having same pair of vid and itemid, it only does an insert on the table instead of update whereas It shows rows being updated also in this following tutorial
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r41/dataload/dataload.htm
I need to be able to update price every time I upload the same pair of vid and itemid. Any help would be highly appreciated.
Thanks
Saurabh Jain