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 / 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
Explain what are the tables of auto invoice?
What is sca and how is it useful?
tell me the scenarios of the independent in reports
How can a process be deployed in soa?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is the concept of soa governance?
How can you achieve loose coupling in soa framework?
Explain oracle apps architecture.
What are the different components of soa suite?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
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
What do you understand by a set of books?
Is soa a part of oracle fusion middleware?
how can develope the po variance and po summary report? with tables mandatory columns and query please?