How can I create data load wizard for multiple tables?
Somewhere i could read that i should create a view and use the data load wizard with it. A view can not be insert or update so it has to create a trigger. So it is ok but I do not know how can i exactly do it in apex oracle..
I have for instance three tables. AREA(area_id, area_measure), and AREA_ITEM(area_id, area_item_type_id, area_item_measure) and AREA_TYPE(area_item_type_id, area_type_name) (the aree type has only three options, so i only need to upload area and its items. So I have a CSV with plenty of datas, so i want to simply upload. How can i do it?
data rows examples
area id area measure area item type id area item measure
1 12 1 12
2 24 1 10
2 24 2 14
3 22 2 22