create

  CREATE OR REPLACE FUNCTION sommeDistance(code IN CHAR)
  RETURN NUMBER
  IS distance NUMBER;
  BEGIN
    SELECT SUM(Distkm)
    INTO distance
    FROM DKCLD
    WHERE CPArrivee LIKE code OR CPDepart LIKE code;
    RETURN distance;
  END;

  SELECT SUM(Distkm) FROM DKCLD WHERE CPArrivee LIKE '33000' OR CPDEPART LIKE '33000'

  SET SERVEROUTPUT ON;

  CREATE OR REPLACE TRIGGER ETD_CPV_INSERT0 AFTER INSERT OR UPDATE
  ON CPV
  when (new Code_Postallike  like '___000' )/* meilleur que le if*/
  BEGIN
  FOR EACH ROW
   /*IF :new Code_Postal like '___000' then*/
  SYS.DBMS_OUTPUT.PUT_LINE('Il faudra rentrer la table des distances');
   /*END IF*/
  END;

  GRANT SELECT ON CPV FROM ETD