I'm very new to Oracle and I'm really looking for a quick answer. I would also appreciate an example of how to do this, but...
My problem is that I want to be able to create a new record in TableB when a new record is created in TableA. In other words, automated synchronization of the two tables, but I need to be able to select certain fields from TableA and be able to add new fields for entry into TableB at the same time. Here's my example...
A new record in TableA is created on 9/24/2004 10:04:01AM as such:
EmplID First Last Dept
000001 Bob Saucier Sales
I need to create a new record in TableB with the following:
EmplID First Last Date
000001 Bob Saucier 9/24/2004
Hopefully I've explained this well enough that someone could help me out. Will a trigger work in this case or is there a better way? And how do I do it?