Requirement : There is a table called TabA which has two columns empId, Dept. one empId can work for two department(Dep1, Dep2). Customer will be responsible for updating depart1 through UI, we need to write a code to insert same employee id into department 2 through db script. There is no other conditions. Whenever there is insertion on dept1, there should be trigger to insert same employee id on dept2 column.
I am not sure how to create a trigger in this case, it would be a great if someone help me on this.