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

Why sql query is slow?

0 Answers  


Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,


What is the difference between syntax error and runtime error?

0 Answers  


What are the three pl sql block types?

0 Answers  


Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,


How do I add a database to sql?

0 Answers  


What is varchar sql?

0 Answers  


what are the security recommendations while using mysql? : Sql dba

0 Answers  


what is the syntax for using sql_variant_property? : Transact sql

0 Answers  


Is pl sql a scripting language?

0 Answers  


What are the different types of database management systems?

0 Answers  


Why do we use view in sql?

0 Answers  


Categories