I created a sequence.
i have 2 tables
I want a trigger that when I insert into 1 table inserts the nextval sequence number, that is no problem But also is there a way so that once that happens it also inserts that same sequence value into another table.
So end result is a new record in table a with the seq value and a new record in table b with same seq value (and rest of fields blank)
thank you for any help