how to write utl file pkg in SQL



how to write utl file pkg in SQL..

Answer / pankajsharma

l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between binary_integer and pls_integer

2 Answers   TCS,


What found sql?

0 Answers  


how do you login to mysql using unix shell? : Sql dba

0 Answers  


What is the difference between nested table and varray?

0 Answers  


Explain the order of sql statement execution?

0 Answers  






What is a parameter query?

0 Answers  


In a table only one column how to update rows

5 Answers   Microsoft,


I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,


What are all the different types of indexes?

0 Answers  


Difference between views and materialized views?

5 Answers   BirlaSoft,


What is dml statement?

0 Answers  


How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,


Categories