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

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

Question Posted / kandulasreekanth

2 Answers
10375 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

Is This Answer Correct ?

9 Yes

0 No

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

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Oracle Apps Technical Interview Questions

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers

Give a brief overview on OrderManagement.

1 Answers Zensar,

Are you familiar with internet architecture of oracle apps 11i?

0 Answers

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers IBM,

What r the type Models in the system parameters of the report?

1 Answers

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

0 Answers

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP