OraFAQ Forum: Client Tools » how to create spool without blank lines

Home » Other » Client Tools » how to create spool without blank lines

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to create spool without blank lines [message #116290]

Tue, 19 April 2005 04:12

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

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Try:

set pagesize 0

Report message to a moderator

Re: how to create spool without blank lines [message #116398 is a reply to message #116290]

Tue, 19 April 2005 17:01

Bill B
Messages: 1971
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;

Report message to a moderator

Re: how to create spool without blank lines [message #116488 is a reply to message #116328]

Wed, 20 April 2005 06:25

ntnboi
Messages: 17
Registered: April 2005
Location: Italy - Rome

Junior Member

thank you to all!

with PAGESIZE 0 I have resolved Wink

Wink

Regards.
Antonio.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 02:59:22 CST 2025