oracle colb 导入导出,使用Oracle SQL Developer将CLOB导出到文本文件

如果您可以访问数据库文件系统框,您可以执行以下操作：

CREATE OR REPLACE DIRECTORY documents AS 'C:\';

SET SERVEROUTPUT ON

DECLARE

l_file UTL_FILE.FILE_TYPE;

l_clob CLOB;

l_buffer VARCHAR2(32767);

l_amount BINARY_INTEGER := 32767;

l_pos INTEGER := 1;

BEGIN

SELECT col1

INTO l_clob

FROM tab1

WHERE rownum = 1;

l_file := UTL_FILE.fopen('DOCUMENTS', 'Sample2.txt', 'w', 32767);

LOOP

DBMS_LOB.read (l_clob, l_amount, l_pos, l_buffer);

UTL_FILE.put(l_file, l_buffer);

l_pos := l_pos + l_amount;

END LOOP;

EXCEPTION

WHEN OTHERS THEN

DBMS_OUTPUT.put_line(SQLERRM);

UTL_FILE.fclose(l_file);

END;

/

你也可能会发现这个previous question about UTL_FILE很有用.它解决导出为CSV.不过,我对于UTL_FILE如何处理CLOB不了解或经验.