少了符号'/':SPOOL E:\SP.txt ;
declare
v1 varchar2(20);
begin
select ename into v1 from emp where empno = 7369;
dbms_output.put_line(v1);
end;
/
SPOOL OFF;
declare
v1 varchar2(20);
begin
select ename into v1 from emp where empno = 7369;
dbms_output.put_line(v1);
end;
/
SPOOL OFF;
我本来也是要用dtl_file来做的,可是要在init.ora中加入一个参数,还要重启数据库,所以不适合,
declare
v1 varchar2(20);
begin
select ename into v1 from emp where empno = 7369;
dbms_output.put_line(v1);
end;
/
还有如果执行select语句的话可以把结果输出到文件中(e:\sp.txt)
但如何把变量输出到文件中呢?谢谢!
变量用
dbms_output.put_line嘛,