how to write utl file pkg in SQL

Question Posted / rajesh

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

More SQL PLSQL Interview Questions

What does seeding a database mean?

How many sql databases can you have on one server?

How are functions and procedures called in PL/SQL?

What is the use of double ampersand (&&) in sql queries? Give an example

What are the built in functions of sql?

what is a constraint? : Sql dba

what is meant by tuning and tk proof?

What is sql comments?

what is try_catch block in procedure

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

Can two tables have same primary key?

List out the acid properties and explain?

For more SQL PLSQL Interview Questions Click Here