I do have 3 tables. I want to generate ID for each below table and that should be unique across each table. Table1 ID - primary ID 1 -> 2 -> 3 Table2 ID - primary ID 4 -> 5 Table3 ID - primary ID 6 -> 7 -> 8 Whenever a new entry is made to the above tables it should generate unique values across the tables For next time when I want to insert 2 records to table 1 it should be Table1 ID - primary ID 9 -> 10.
Do we can create a trigger to accomplish this in Oracle