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
- 7529 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
please send me forms, xml pulisher questions,answers
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Tell me how to debug the report?
do you know is it possible to run the interface without using oracle apps?
how can i print random rows in plsql table
what is pay run id ?
Do you know what is applysys in oracle application database schema, what is apps?
Can you define an erp system?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
In sequence i want to 11 and 15th values how we will write?
What does appl_top directory contain?
What do you understand by soa?
What is oracle soa suite?
can we get profile values in report without using user exists is it possible how?
where to define interorganization transaction charges and what are the different options?
