sql query insert auto_increment value code example

Example: how to alter auto increment in sql

INSERT INTO Persons (Personid,FirstName,LastName)

VALUES (seq_person.nextval,'Lars','Monsen');