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

can we write sql statement in Format trigger?

4 Answers  

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---

Form development process?

1 Answers  

---

in one report using two layout models.if yes how to do

3 Answers   Wipro,

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---

How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

sourcing in GL

1 Answers   Convergys,

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---