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 percent sign in sql?

720


What is sqlerrd?

528


How do I add a primary key to a table?

543


what is union, minus and interact commands? : Sql dba

661


What is the maximum number of columns in sql table?

551






Which command is used to call a stored procedure?

505


What does := mean in pl sql?

555


What does select count (*) mean in sql?

552


Is left join inner or outer by default?

523


What are the two types of exceptions in pl/sql?

548


Can a primary key be a foreign key?

577


Is hadoop a nosql?

575


What is delete command in sql?

558


How to get list of all tables from a database?

631


What are different types of statements supported by sql?

609