how to write utl file pkg in SQL

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a field in a database?

566


What is the maximum number of rows in sql table?

542


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

511


What are types of indexes in sql?

537


How do I count records in sql?

514






Why do we use cursors?

507


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

640


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

551


What are the different types of functions in sql?

511


How to return an array from java to pl/sql?

587


Explain polymorphism in pl/sql.

635


what is self-join? : Sql dba

565


What are the basic sql commands?

547


What is Difference Between Unique and Primary Key Constraints?

604


Explain the difference between drop and truncate commands in sql?

527