Inserting into multiple columns using generated values and retaining same order
Does anybody have any idea how this table insert requirement can be achieved?
I have a table which is inserted into from multiple threads concurrently.
(SQL> insert into TABLE_TEST (seq_id, thread, create_date) values (my_seq.nextval, '$THREAD', current_timestamp); )
Two of its columns are generated values.
- column A - sequence.nextval
- column B - current_timestamp
I need to maintain the order of the table is the same, whether I order by Column A or column B. In other words column A and column B need to be in the same sequential order as each other.