Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8711 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
How can we import the data into a database using sql * loader?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
In hierarchical structure of a database? we have write query from where we should start?
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
What are basic steps for AIM?
where to define interorganization transaction charges and what are the different options?
What is template?
Can you define an erp system?
what are the different calculation columns available in reports?
What are the files you have used in the part of Conversion and Interfaces?
what are the types of interfacing?
can we use commit in trigger? If yes how?
Oracle Apps Technical 
