数据库服务名为:cncworks
数据库sys用户密码为:gesys
数据库simpdba(普通用户)密码为:well
现有一个数据库表:
create table simpdba.test
(
id number(1),
name varchar2(20),
address varchar2(20)
);
内容如下:
insert into simpdba.test values(1,’quchch’,’sy’);
insert into simpdba.test values(2,’chenwen’,’dl’);
insert into simpdba.test values(3,’wangbh’,’xj’);
insert into simpdba.test values(4,’liuliang’,’sx’);
insert into simpdba.test values(5,’liben’,’jl’);
COMMIT;
希望在硬盘Dut下输出一个文件a.txt,内容格式如下:
1|quchch|sy
2|chenwen|dl
3|wangbh|xj
4|liuliang|sx
5|liben|jl
方法一:利用SQL/PLUS的SPOOL
1、建立一个文件D:ex.sql内容如下
set heading off
set echo off
set term off
set line 0
set pages 0
set feed off
spool duta.txt
select id||’|’||name||’|’||address as ne
数据库sys用户密码为:gesys
数据库simpdba(普通用户)密码为:well
现有一个数据库表:
create table simpdba.test
(
id number(1),
name varchar2(20),
address varchar2(20)
);
内容如下:
insert into simpdba.test values(1,’quchch’,’sy’);
insert into simpdba.test values(2,’chenwen’,’dl’);
insert into simpdba.test values(3,’wangbh’,’xj’);
insert into simpdba.test values(4,’liuliang’,’sx’);
insert into simpdba.test values(5,’liben’,’jl’);
COMMIT;
希望在硬盘Dut下输出一个文件a.txt,内容格式如下:
1|quchch|sy
2|chenwen|dl
3|wangbh|xj
4|liuliang|sx
5|liben|jl
方法一:利用SQL/PLUS的SPOOL
1、建立一个文件D:ex.sql内容如下
set heading off
set echo off
set term off
set line 0
set pages 0
set feed off
spool duta.txt
select id||’|’||name||’|’||address as ne