开始
前期准备:
SQL> create directory utl as '/home/oracle/test'; Directory created. SQL> grant execute on utl_file to scott; Grant succeeded. SQL>
文件操作:
declare fn utl_file.file_type; OutputRecord VARCHAR2(255); begin OutputRecord :='abcdefg'; fn:=utl_file.fopen('UTL','test.txt','W'); utl_file.put (fn, OutputRecord); utl_file.new_line (OutputFile); utl_file.fclose(fn); end;
结束
本文转自健哥的数据花园博客园博客,原文链接:http://www.cnblogs.com/gaojian/archive/2012/12/06/2805226.html,如需转载请自行联系原作者