CREATE OR REPLACE
  FUNCTION HitungBatal RETURN NUMBER
  IS
  batal_count NUMBER;
  BEGIN
  SELECT COUNT(*) INTO batal_count
  FROM pendaftaran
  WHERE status='Batal';
  RETURN batal_count;
 END;
 /