频道栏目
IT货架 > > 正文
Canoneread/writefilesfromPL/SQL?
网友分享于:Jun 13, 2018 12:03:01 AM    来源: IT货架   

The UTL_FILE database package can be used to read and write operating system files.

A DBA user needs to grant you access to read from/ write to a specific directory before using this package. Here is an example:

Provide user access to the UTL_FILE package (created by catproc.sql):

Copy and paste these examples to get you started:

Write File

Read File

NOTE: UTL_FILE was introduced with Oracle 7.3. Before Oracle 7.3 the only means of writing a file was to use DBMS_OUTPUT with the SQL*Plus SPOOL command.

广告服务联系QQ:1134687142 | 网站地图

版权所有: IT货架- 内容来自互联网,仅供用于技术学习,请遵循相关法律法规. 京ICP备11030978号-1