XYZ LTD 49 LANE,GEORGE SQUARE LONDON ABC LTD A/CNO : DR/CR: 10 Lane ,kksd Sydne Voucher No: Date: We have credited to your account with a Sum of $5000 Being damge of material Jan-07 PARTICULARS AMOUNT ---------------------------------------------------------------------------------------------------------- Damge of material Jan-07 amount $5000 $5000 For XYZ LTD --------------------------------------------------------------------------------------------------- Output should be as above for each Customer ..All values like Customer name ,A/C No ,Debit /Credit ,Voucher No ,Date can be read from the table other remains same . I want the matter should be print in the same format shown above ..Is it possible in Sql or in Pl/sql ?..Pls advise give sample script..thanks in advance.