DROP TABLE Personne;
DROP SEQUENCE Personne_Sequence;

CREATE TABLE Personne (
        numero   INTEGER NOT NULL,
        nom      VARCHAR(25),
        prenom   VARCHAR(25),
        age      INTEGER,
	PRIMARY KEY (numero)
   );

CREATE SEQUENCE Personne_Sequence
START WITH 1
INCREMENT BY 1;

CREATE TRIGGER Personne_Trigger
  BEFORE INSERT 
  ON Personne
  FOR EACH ROW
    BEGIN
      SELECT Personne_Sequence.NEXTVAL 
      INTO :NEW.numero 
      FROM DUAL;	
    END;
/
INSERT INTO Personne(nom,prenom,age) VALUES ('DUVALLET','Claude',37);