问几个sqlplus的问题

SweetMemory · 发表于 2005-1-30 19:18

1、用spool ……生成的文本文件中开头会出现：
SQL>    select a.usrid,b.groupid
  2    from tab1 a,tab2 b
  3    where a.usrid=c.usrid and c.groupid=b.groupid;
结尾会出现：
112 rows selected.

如何在sqlplus中去掉这个头和尾？在spool生成的文件中无上述字样。

2、在sqlplus中运行select* from a;如何不在屏幕打印输出数据？

eygle · 发表于 2005-1-30 22:01

for example:

[php]

[oracle@jumper oracle]$ more sp.sql
set heading off
set feedback off
set term off
spool a.log
@test.sql
spool off
exit
[oracle@jumper oracle]$ more test.sql
select username from dba_users;
[oracle@jumper oracle]$ sqlplus -S "/ as sysdba" @sp
[oracle@jumper oracle]$ more a.log
SYS
SYSTEM
OUTLN
SCOTT
HAWA
CSMIG
EYGLE
[oracle@jumper oracle]$
.
[/php]

SweetMemory · 发表于 2005-1-30 22:24

还是有个郁闷的头和尾

adm.ksh
#!/bin/ksh
   sqlplus name/passwd@dbname<<EOF
   set pagesize 0
   set feedback off
   set term off
   set linesize 150
   set heading off
   spool /export/home/oracle/TEST/first/admin.dat
   @/export/home/oracle/TEST/ONE/adm.sql （不好意思刚才写错了）
   spool off;
EOF

调用：nohup ./adm.ksh &

first >head admin.dat
SQL>    @/export/home/oracle/TEST/ONE/adm.sql --头
4300 20040508 统计查询
……略

first >tail -2 admin.dat
7300 20041010 统计查询
SQL>    spool off; -尾