請問應如何自動generate letter using Oracle? 若想發信給未付錢的會員，應如何辦？ 我想來想去都不懂。除了basic的code 之外。 SET SERVEROUTPUT ON FORMAT WORD_WRAPPED SET LINESIZE 20 BEGIN begin dbms_output.put_line('To : J. Brown 3 Any St, Somewhere'); dbms_output.put_line('....(sysdate)'); dbms_output.put_line('Dear John, You currently have $x outstanding on your annual subscription of $y. It would be appreciated if these arrears could be paid before the end of April {next month} Yours sincerely Club Treasurer'); end; / The club treasurer wishes to send a reminder letter to all members who have not paid their current subscriptions. Write a PL/SQL program to produce such a letter for each member with fees outstanding. The letter is to take the form shown below : To : J. Brown 3 Any St, Somewhere Date : 27th March, 2005 {today’s date} Dear John, You currently have $x outstanding on your annual subscription of $y. It would be appreciated if these arrears could be paid before the end of April {next month} Yours sincerely Club Treasurer 請各位善心人士幫忙一下。。對不起，麻煩了。 謝謝