DECLARE

v_id autor.id_autor%TYPE;

BEGIN

SELECT MAX(id_autor) INTO v_id FROM autor;
v_id := v_id + 10;

INSERT INTO autor(id_autor, nume, prenume)
VALUES(v_id, '&nume', '&prenume');
END;
/