Devart Forums

When I insert record into Oracle with uniloader, How to use auto increase column?
eg, sql: insert tab_a (id, name) value (id.nextval, 'tom');

Hello.

Sequence cannot be used in TUniLoader. To solve the problem, you should create a trigger, that will fill in the "auto increase" column (using sequence) when inserting a new record.