Update or insert in View(which is a combination of tables)
(I am new in oracle form or report and even in IT. Thank for your help first ^^)
I am creating a form which is a master - detail form. In the master, for example, "Sport" is shown. Then, in detail part, some sport should come up like "football", "basketball" etc.
The way I am using is just use the data wizard and create a relationship between them. This way is OK for just SELECT but not work in INSERT or UPDATE.
And one of my AP said, it should be make use of temp data block to save the detail record, and read all the detail filed and make use of API or procedure to INSERT and UPDATE.