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

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

how do you describe O2C along with tables

0 Answers   TCS,

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

---

what are the difference between oracle discoverer and report6i

1 Answers  

---