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*/
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
Do you know what is applysys in oracle application database schema, what is apps?
How to create a purchase order without a requisition?
tell me the scenarios of the independent in reports
In oracle application how do you debug or trace errors?
What do you understand by concurrent programs?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
tell my any difficult situtation you solved in your experience in your company?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
what is the difference between request group and request security in oracle apps?
In sequence i want to 11 and 15th values how we will write?
what is pay run id ?
What is count(*) from po_vendors(any table)?
Plz anybody send me Technical specification for AP Interface
Is soa a part of oracle fusion middleware?