Spacing for a select statement
2006-10-04 12:06:23
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>
|
- Spacing for a select statement,
Joni Moyer <=
|
|
|