UTL_FILE « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. UTL_FILE
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.fopen to open a file
4.Use UTL_FILE.FCLOSE to close a file
5.Use UTL_FILE to read from a file and insert into the lecturer table.
6.Use UTL_FILE to print a transacript to a file.
7.Catch different UTL_FILE related errors
8.Save data in a cursor to a file
9.Load the data into table myTable. You may use any valid number for column c1's data.