一、
1: 在pl/sql dev里面把这个表的内容SELECT出来;
2:拷贝,复制到EXCEL中
3:把EXCEL文件另存为 .CSV文件
4:用记事本把.CSV文件打开!
二、
set linesize 1000
set pagesize 0
set echo off
set termout off
set heading off
set feedback off
spool c:\test\try2.txt
select id||','||user_name||','||age from us;
spool off
/
三、使用utl_file包
CREATE OR REPLACE PROCEDURE mytest
IS
test_handle UTL_FILE.file_type;
BEGIN
test_handle := UTL_FILE.FOPEN('DIR_DUMP','test.txt','w');
FOR x IN (SELECT * FROM TEST) LOOP
UTL_FILE.PUT_LINE(test_handle,x.ID || ',' || x.NAME ||',');
END LOOP;
UTL_FILE.FCLOSE(test_handle);
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SUBSTR(SQLERRM,1,2000));
END;
/