SQLPlus - How to spool without query string?

[Son KwonNam]

Hello,

When I spool select query results with SQL*Plus,
It always add query strings to the spooled file.

How to spool without query string?

I need to use the spooled file in a cron job.
But because the spooled file has garbage strings, it's very difficult to
use that.

Regards,
KwonNam.

[Isa]

Hi:
you can put at the beginning of the select:
set termout off
set arraysize 5
set echo off
set verify off
set heading off

This removes all the text from the query result. Only remains the
values of the select
I hope it's usefull to you.
Regards,
Isa

[Noel]

User Isa wrote:
Hi: you can put at the beginning of the select: set termout off set arraysize 5 set echo off set verify off set heading off

You could also add "set pages 0" to eliminate empty line after each page.

--
Noel

[T]

Seek!!
http://www.ss64.com/orasyntax/plus_set.html




"Noel" <tbal@go2.pll-l> wrote in message
news:dgtspl$5mh$1@inews.gazeta.pl... User Isa wrote: Hi: you can put at the beginning of the select: set termout off set arraysize 5 set echo off set verify off set heading off You could also add "set pages 0" to eliminate empty line after each page. -- Noel

[DA Morgan]

Isa wrote: Hi: you can put at the beginning of the select: set termout off set arraysize 5 set echo off set verify off set heading off This removes all the text from the query result. Only remains the values of the select I hope it's usefull to you. Regards, Isa

Why arraysize 5? That should do nothing but slow down the query
by quite a bit. I'd suggest you try with an arraysize of 100-200
as a general rule.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Son KwonNam]

Thank you, all.
It works perfectly.

But when I try this, I had to make *.sql script file
and run like "sqlplus user/passwd @test.sql"

It did not work interactively on sql*plus.

Anyway that's what I exactly wanted.

Thanks again.

Isa wrote: Hi: you can put at the beginning of the select: set termout off set arraysize 5 set echo off set verify off set heading off This removes all the text from the query result. Only remains the values of the select I hope it's usefull to you. Regards, Isa

[Son KwonNam]

When I tried another query which has alot of result rows,
it did not have any query string but, it had the following line.
--------------------------
99 rows selected.
--------------------------

Is it possible to remove that line?

Thanks.
~
Son KwonNam 쓴 글: Thank you, all. It works perfectly. But when I try this, I had to make *.sql script file and run like "sqlplus user/passwd @test.sql" It did not work interactively on sql*plus. Anyway that's what I exactly wanted. Thanks again.

[Noel]

User Son KwonNam wrote: When I tried another query which has alot of result rows, it did not have any query string but, it had the following line. -------------------------- 99 rows selected. -------------------------- Is it possible to remove that line?

SET FEEDBACK OFF

--//**

SQL> select * from cat where rownum = 1;

TABLE_NAME TABLE_TYPE
------------------------------ -----------
AA TABLE

SQL> set feedback on
SQL> /

TABLE_NAME TABLE_TYPE
------------------------------ -----------
AA TABLE

1 row selected..

SQL> set feedback off
SQL> /

TABLE_NAME TABLE_TYPE
------------------------------ -----------
AA TABLE
SQL>

--
TomekB tbal@go2.pl-l