ADSM-L

Spacing for a select statement

2006-10-04 12:06:23
Subject: Spacing for a select statement
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 4 Oct 2006 08:26:54 -0400
Hello everyone,

I was just wondering if you would happen to know how I might be able to
fit all of the output on one line for the below select statement?  Any
suggestions are appreciated.  Thanks!

select node_name,filespace_name,backup_start,backup_end from filespaces
where node_name like 'NAS%' or node_name like 'SERVER%'

NODE_NAME              FILESPACE_NAME               BACKUP_START
BACKUP_END
------------------     ------------------     ------------------
------------------
NAS_SERVER_4_OFFS-     /.etc_common                   2006-10-03
2006-10-03
 ITE                                             20:57:05.000000
20:59:52.000000
NAS_SERVER_4_OFFS-     /home4                         2006-10-03
2006-10-03
 ITE                                             20:57:05.000000
22:01:03.000000
NAS_SERVER_4_OFFS-     /home4/home4dir1               2006-10-03
2006-10-03
 ITE                                             20:57:05.000000
22:24:09.000000
NAS_SERVER_4_OFFS-     /home4/home4dir2               2006-10-03
2006-10-04
 ITE                                             20:57:05.000000
01:39:44.000000
NAS_SERVER_4_OFFS-     /issue                         2006-08-02
2006-08-03


********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************

<Prev in Thread] Current Thread [Next in Thread>