Use utl_file.fopen to open a file : UTL_FILE « System Packages « Oracle PL / SQL






Use utl_file.fopen to open a file

  
SQL>
SQL> declare
  2    l_file_handle utl_file.file_type;
  3  begin
  4    l_file_handle := utl_file.fopen( '/tmp', 'tom.data', 'w' );
  5  end;
  6  /

SQL> --

   
  








Related examples in the same category

1.Writing "Hello World!" to a File
2.Use UTL_FILE.PUT_LINE to write a line of text to a file
3.Use UTL_FILE.FCLOSE to close a file
4.Use UTL_FILE to read from a file and insert into the lecturer table.
5.Use UTL_FILE to print a transacript to a file.
6.Catch different UTL_FILE related errors
7.Save data in a cursor to a file
8.Load the data into table myTable. You may use any valid number for column c1's data.