I have requirement where trigger needs to be created on same table.
Here is the condition,
When A code is inserted into table at the same time trigger gets involved and writes B code
Where Type is column which will be having value as A then need to insert Type column only With B value rest thing will remain same .
Please assist