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>;

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

Answer / birla

Aditya Write the code

Answer / ram

select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

How can you achieve loose coupling in soa framework?

0 Answers  

---

What is the most critical part which you had faced in your project ?

1 Answers   LG, Satyam, Tech Mahindra,

---

Difference between triggers and procedures?

2 Answers  

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

why r u transer the data base tables to flat file and what is use

2 Answers  

---

Which oracle apps version you are very confident in?

0 Answers  

---

Tell me some errors names and number what u got while developing the reports?

1 Answers  

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

tell me the scenarios of between pages in reports

5 Answers  

---

What is menu.

2 Answers   Accenture,

---