Home » SQL & PL/SQL » Client Tools » how to create spool without blank lines
how to create spool without blank lines [message #116290] Tue, 19 April 2005 04:12 Go to next message
ntnboi
Messages: 17
Registered: April 2005
Location: Italy - Rome
Junior Member

Hi, is possible create a spool file without blank lines?

I use follow parameter:

set head off
set feedback off
set term off
set lines 15
spool ./tot_user.lst
select count(USERNAME) from v$session where username is not null;
spool off
quit

result in spool (where $ = is end of line):

-------------------
$
4$
-------------------

is possible obtain only result without first blank line?

---------------
4$
---------------

[Updated on: Tue, 19 April 2005 04:22]

Report message to a moderator

Re: how to create spool without blank lines [message #116328 is a reply to message #116290] Tue, 19 April 2005 08:41 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Try:

set pagesize 0
Re: how to create spool without blank lines [message #116398 is a reply to message #116290] Tue, 19 April 2005 17:01 Go to previous messageGo to next message
Bill B
Messages: 1968
Registered: December 2004
Senior Member
also, don't you want to know how many sessions for each user.

select count(*),username
from v$session
where username is not null
group by username;
Re: how to create spool without blank lines [message #116488 is a reply to message #116328] Wed, 20 April 2005 06:25 Go to previous message
ntnboi
Messages: 17
Registered: April 2005
Location: Italy - Rome
Junior Member

thank you to all!

with PAGESIZE 0 I have resolved Wink

Regards.
Antonio.

Previous Topic: iSQL*Plus: Adjusting Time-out limits
Next Topic: Installation problem (ISQL*PLUS)
Goto Forum:
  


Current Time: Tue Aug 11 08:41:14 CDT 2020