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 are keys in sql?

724


What is online transaction processing (oltp)?

749


What is the difference between in and between in sql?

773


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

860


How is sql used in oracle?

756






What does where 1 1 mean in sql?

746


What is a call statement? Explain with an example.

745


Explain the the delete statements in sql?

756


Define a temp table?

755


What is bind reference and how can it be created?

771


In a distributed database system, can we execute two queries simultaneously?

750


What is acid property in a database?

762


Define the select into statement.

778


Is mariadb a nosql database?

760


How can you fetch first 5 characters of the string?

707