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
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Is soa a part of oracle fusion middleware?
List the types of flexfield?
what is pay run id ?
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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Do you know what is applysys in oracle application database schema, what is apps?
testing tools?
what are the prerequisites for costing transactions?
In support project one ticket alloted which steps follows manualy tell me ?
how can i print random rows in plsql table
In sequence i want to 11 and 15th values how we will write?
Do you know where we can check the status of po?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?