Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8712 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / 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 |
What is sca and how is it useful?
How to send the e-mail notification in XML Pub Report?
which parameters passed in report in oracle developer how to pass
in ap_terms table what data will be stored
What are the files you have used in the part of Conversion and Interfaces?
name all status attributes.
In hierarchical structure of a database? we have write query from where we should start?
In oracle application how do you debug or trace errors?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
What are file in oracle.
what is Flex mode and Confine mode?
what is the differences between internal requisition and internal sales order?
Oracle Apps Technical 
