请教怎样用plsql将select出来的纪录存成一个文件？

a.控制语句，如set heading off

b.spool 完整文件名

c.查询语句

……

d.spool off

playmud at 2005-1-28 15:18:55 >

set feedback off;　　

set line 1000;

set tab on;

set trims on;

spool c:\emp.txt;

select * from scott.emp;

spool off;

数据量不大的时候可以用

nebulaly at 2005-1-28 15:20:20 >

SQL> set heading off

SQL> set feedback off

SQL> spool c:\a.txt

SQL> @ c:\sql.txt (或执行你的pl/sql)

SQL> spool off

在硬盘C 下已有文件a.txt

jiangchuanli at 2005-1-28 15:40:16 >

http://community.csdn.net/Expert/topic/3326/3326241.xml?temp=.8979303

xpony at 2005-1-28 15:57:26 >

楼主是要求用pl/sql来写吧!不是指在sqlplus里面吧.是不是这个意思?

是的!

ilovemayong at 2005-2-1 14:27:33 >

set serveroutput on

declare

v_date varchar2(80);

begin

select to_char(sysdate,'yyyy-mm-dd') into v_date from dual;

dbms_output.put_line(v_date);

end;

/

jiangchuanli at 2005-2-1 15:33:31 >