PUT_LINE Procedure
This procedure writes the text string stored in the buffer parameter to the open file identified by the file handle. The file must be open for write operations. PUT_LINE terminates the line with the platform-specific line terminator character or characters.The maximum size of the buffer parameter is 32767 bytes unless you specify a smaller size in FOPEN. The default is approximately 1000 bytes, depending on your platform. The sum of all sequential PUT calls cannot exceed 32767 without intermediate buffer flushes.See also "PUT_LINE_NCHAR Procedure".Syntax
UTL_FILE.PUT_LINE (
file IN FILE_TYPE,
buffer IN VARCHAR2,
autoflush IN BOOLEAN DEFAULT FALSE);在调用fopen函数的时候把每行的长度指定为更大。最大可以为32767
This procedure writes the text string stored in the buffer parameter to the open file identified by the file handle. The file must be open for write operations. PUT_LINE terminates the line with the platform-specific line terminator character or characters.The maximum size of the buffer parameter is 32767 bytes unless you specify a smaller size in FOPEN. The default is approximately 1000 bytes, depending on your platform. The sum of all sequential PUT calls cannot exceed 32767 without intermediate buffer flushes.See also "PUT_LINE_NCHAR Procedure".Syntax
UTL_FILE.PUT_LINE (
file IN FILE_TYPE,
buffer IN VARCHAR2,
autoflush IN BOOLEAN DEFAULT FALSE);在调用fopen函数的时候把每行的长度指定为更大。最大可以为32767
解决方案 »
- 急问ORACLE数据库同步的方法步骤!谢谢!
- 数据库b.有这种语法吗?
- 使用sql load的一点困惑
- linux下Oracle 11g的监听无法启动
- SQL语句直接执行快,在程序中慢
- 怎么把秒数的差,计算成天,小时,分,秒?
- ORA-06550: 第 1 行, 第 7 列: PLS-00905: 对象 SYSTEM.GETA 无效 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored
- 公司從國外請來的ocm如是說﹐請各位評評
- 散分需要理由吗
- 数据表排序字段,内容重复的不显示,如何书写SQL语句?
- Developer2000 等待对话框的问题
- 急!!oracle里如何获得一个时间类型,请指教(在线等待)
SQL> exec dbms_output.enable(200000);
UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2,
max_linesize IN BINARY_INTEGER)
RETURN file_type;谢谢楼上啦^_^