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
- 7209 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
What is count(*) from po_vendors(any table)?
What are the different components of soa suite?
What do you understand by soa?
What is a flexfield? List out its types.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What are the Standard Reports and Forms in HRMS?
Can you differentiate between mediator and osb?
How to move the one file from one instance to another instance? And your scripts also?
what is global tempory table?
Which oracle apps version you are very confident in?
How can you achieve loose coupling in soa framework?
What is sca and how is it useful?
Tell me how to find the custom directory in front end?
What is oracle soa suite and what are its different components?
q)what are the validations in sql*loader
