2 Replies Latest reply on Apr 17, 2017 2:42 PM by 3401357

    How to config Alert which send mail?

    3401357

      I have an alert which return 24 lines, my alert send 24 mail, i want to send only one mail with 24 lines.

      How to do this?

       

      SELECT

        placement_num,

        date_ech,

        total

        INTO

        &num_placement,

        &date_echeance,

        &total

      FROM TRS_CALCUL_PLACEMENT_ALL

      WHERE date_ech BETWEEN TRUNC(sysdate) AND TRUNC(sysdate)+31

      capttt.PNG