how to create spool without blank lines [message #116290] |
Tue, 19 April 2005 04:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ntnboi
Messages: 17 Registered: April 2005 Location: Italy - Rome
|
Junior Member |
![ntnboi](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
|
|
|