How to report output like below supplier name date amount abc

How to report output like below

supplier name date amount

abc software jan/11 10000 /* jan month total transactions*/
abc software feb/12 30000 /* feb month total transactions*/
dell computers jan/13 45000 /* jan month total transactions*/

Question Posted / msuman5577

4 Answers
8853 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to report output like below supplier name date amount abc software jan..

Answer / sovan

select supplier_name "supplier name" ,to_char
(trx_date,'mon/yy') "date",amount "amount"||'/*'||to_char(trx_date,'mon')||'
month total transactions */' from <Table_NAME>;

Is This Answer Correct ?

8 Yes

0 No

How to report output like below supplier name date amount abc software jan..

Answer / aditya

Hi,

Just write a report function which takes the date and finds
the month then concatenate it with the text /* (<Month>)
month total transactions*/

Regards,
Aditya

Is This Answer Correct ?

2 Yes

0 No

How to report output like below supplier name date amount abc software jan..

Answer / birla

Aditya Write the code

Is This Answer Correct ?

0 Yes

0 No

How to report output like below supplier name date amount abc software jan..

Answer / ram

select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;