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*/
- 4 Answers
- 7210 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is instead of trigger in where we will use?
In hierarchical structure of a database? we have write query from where we should start?
What are the different components of soa suite?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Do you know what are user profiles in apps. Any examples you can give?
Tell me how to debug the report?
what are the different transaction clauses in AR?
How do you register report in oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
What are the Standard Reports and Forms in HRMS?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
what are the prerequisites for costing transactions?
What do you understand by soa and what are the benefits of using this architecture?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are the benefits of using soa architecture?
