O'Reilly logo

Oracle Database 12c PL/SQL Advanced Programming Techniques by John Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

CHAPTER3

utl_file Package

Purpose

This chapter teaches you how to configure, deploy, manage, and troubleshoot the utl_file package. The utl_file package was introduced in Oracle version 7 as a PL/SQL tool to sequentially read files from and write files to the operating system. Oracle9i Database added limited ability to randomly read files by shifting the pointer forward or backward through a file. Oracle Database 10g enabled the utl_file package to use virtual directories rather than physical path locations. Oracle Database 10g also removed the physical limitation on writing external files through the dbms_output package. There are no changes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required