I have been studying the Trigger process. It is my understanding the Oracle commit action must first occur to make the new row available. Is this correct? I am creating a DataMart schema that will capture data (in real time) being inserted into a different database. Do I need to set up a scheduled event (at the end of the day) to load the new rows
into the DataMart?
into the DataMart?