select supplier_name ,to_char (sysdate,'mon/yy'),amount||'/

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 / ram

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

Answer Posted / ram

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a value set? List its various types.

1144

How do you register report in oracle apps?

1136

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3078

Can you differentiate between mediator and osb?

1193

Plz anybody send me Technical specification for AP Interface

2617

what are the different transaction clauses in AR?

2169

testing tools?

2303

What are the different components of soa suite?

1265

tell me the scenarios of the independent in reports

2567

Can you explain the difference between architecture followed in 10g & 11g?

1122

Can we create tables in apps schema?

1184

What does appl_top directory contain?

1168

What is oracle soa suite and what are its different components?

1281

can we get profile values in report without using user exists is it possible how?

2935

tell me the scenarios of the independent in reports

2658