Answer / samad

HI,

We will use following three functions to generate the file.

1)Utl_File.fopen = To open (or) Create the file
2)Utl_File.Put_line = To Transfer the data into the File.
3)Utl_File.fclose = To close the File after Data
transfer.

REGARDS
SAMAD
samadsmilein@gmail.com

Answer / muneer

IN ABOVE ANS ONLY FOPEN IS A FUNCTION REMAINING ARE
PROCEDURE
FUN IN UTL FILE ARE
F OPEN
IS OPEN
FOPEN NCHAR

MUNEER

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

How will u register concurrent request ?

1 Answers   Convergys,

---

cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

What do you understand by concurrent programs?

1 Answers  

---

What do you understand by soa and what are the benefits of using this architecture?

1 Answers  

---

Can you differentiate between mediator and osb?

1 Answers  

---

How to print multi currency,multi language in xml?

1 Answers  

---

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---