plsql - oracle中如何使用utl_file写入文件

Question

如何使用 put 函数。我的程序不是用 put 编译的。但 putline 工作正常。我想在同一行打印

Answer 1

下面是使用 UTL_FILE.PUT 和 UTL_FILE.PUT_LINE 调用的代码示例:

declare 
  fHandle  UTL_FILE.FILE_TYPE;
begin
  fHandle := UTL_FILE.FOPEN('my_directory', 'test_file', 'w');

  UTL_FILE.PUT(fHandle, 'This is the first line');
  UTL_FILE.PUT(fHandle, 'This is the second line');
  UTL_FILE.PUT_LINE(fHandle, 'This is the third line');

  UTL_FILE.FCLOSE(fHandle);
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Exception: SQLCODE=' || SQLCODE || '  SQLERRM=' || SQLERRM);
    RAISE;
end;

这个输出看起来像:

This is the first lineThis is the second lineThis is the third line

分享和享受。