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
- 7709 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
Are you familiar with internet architecture of oracle apps 11i?
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
tell me the scenarios of the independent in reports
Which oracle apps version you are very confident in?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Can you differentiate between mediator and osb?
How can a process be deployed in soa?
How many schemas we have? how many you have used?
What is count(*) from po_vendors(any table)?
What are file in oracle.
What do you understand by a set of books?
How to create a purchase order without a requisition?
List the types of flexfield?
Can you explain the difference between architecture followed in 10g & 11g?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
