Can I read Using Oracle UTL_FILE for CSV Reports on EtoBox?

Using Oracle UTL_FILE for CSV Reports by Samir Benakli is a document available to read on EtoBox.

What is Using Oracle UTL_FILE for CSV Reports about?

The UTL_FILE package allows PL/SQL programs to read from and write to operating system text files. It uses directory objects to map to OS directories. The example code shows how to: 1) Create a directory object mapping to an OS directory 2) Define a procedure to fetch sales data from a cursor 3) Open a CSV file using UTL_FILE and write each record along with line terminators 4) Close the file after all records are written The generated CSV file can then be imported to other environments.

Author

Samir Benakli

Language

EN