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');
use uniloader on auto increase column
-
DemetrionQ
- Devart Team
- Posts: 271
- Joined: Wed 23 Jan 2013 11:21
Re: use uniloader on auto increase column
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.
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.