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 [EMAIL PROTECTED] ********************************
