Sequence

SELECT MAX(empno)
INTO   :new_empno
FROM   emp;

INSERT INTO emp
VALUES (:new_empno + 1, ...);

    --atau dengan mengunakan sequence
INSERT INTO emp
VALUES (emp_seq.NEXTVAL, ...);

SELECT emp_seq.NEXVAL
INTO   :new_empno FROM dual;