Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
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?
WHERE date_ech BETWEEN TRUNC(sysdate) AND TRUNC(sysdate)+31
See these MOS Docs
MOS Doc 855401.1
MOS Doc 1450319.1