I need to increment my id. I have to increment by using sequence in oracle database. When i use INSERT INTO XXX (seq_xxx.nextval, ....)
i have error invalid column name
.
EDIT: The problem was in capital letters SEQ_XXX.NEXTVAL
is working fine.
Insert Statement in Oracle:
insert into XXX (id, ...) values (seq_xxx.nextVal, ...)
Note: (id, ...) = table column names
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With