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*/
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / aditya
Hi,
Just write a report function which takes the date and finds
the month then concatenate it with the text /* (<Month>)
month total transactions*/
Regards,
Aditya
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Presently u are working in which version?
What is the use of format trigger?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
tell my any difficult situtation you solved in your experience in your company?
Where we can write a PL/SQL code in report triggers?
how can we return morethan one parameters in procedure?
How to link modules in apps
what do you mean by value sets
in procedure how to return a value
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Please let me know the differance between Master Item and organization Item in Inventory.
Is soa a part of oracle fusion middleware?