How to use oracle sequence.nextval

Question

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.

Answer 1

Insert Statement in Oracle:

insert into XXX (id, ...) values (seq_xxx.nextVal, ...)

Note: (id, ...) = table column names