Create a collection when there is no record. And join the collection query with the query from the table.
where collection_name = 'EMP_COL'
More collection information can be found here --> https://docs.oracle.com/database/121/AEAPI/apex_collection.htm#AEAPI531
thanks for the suggestion but the statement is too generic just saying ctreating colls and plugin to report query surely isn't giving me enough juicy.
Where exactly to you fire that snippet code to capture & insert?
There is no plugin needed here.
You just need to truncate and create a collection on page load or refresh.
The reason that I suggested to use a collection in case the user decided not to save the record, there is no need to delete any record from the table. And when the user decided to save the record, you just need to move the record from the collection into the table.