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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

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

0 Answers   IBM,

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

---

What do you understand by a set of books?

0 Answers  

---

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,

---

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

Can you have two functions with the same name in a pl/sql block?

5 Answers   TCS,

---

diff between key and descriptive flexfield.

4 Answers   Convergys,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---