what are the functions you are used in utl_file at the time
of transferring the data?

Answer Posted / 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

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can i print random rows in plsql table

1944


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

641


What is a flexfield? List out its types.

669


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1892


please send me forms, xml pulisher questions,answers

1658






what are the prerequisites for costing transactions?

2635


In support project one ticket alloted which steps follows manualy tell me ?

2227


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2133


what are the balancing segments in AR?

1657


What is oracle soa suite and what are its different components?

652


In oracle application how do you debug or trace errors?

643


What are do's and dont's of Interface?

1909


testing tools?

1758


How to move the one file from one instance to another instance? And your scripts also?

617


how do you describe O2C along with tables

2315