select statement
2005-03-28 11:14:46
Hey!
I am trying to put together a select statement to find all archives for
CS-NICE-STORAGE, but it is showing me the output in the below format. Is
there a way that I can get all of the info. on 1 line and also make the
archive_date split into date & time? Thanks in advance!
Here is the command I was running: select node_name,filespace_name,hl_name
|| ll_name as "File",archive_date,class_name from archives where
node_name='CS-NICE-STORAGE'
NODE_NAME: CS-NICE-STORAGE
FILESPACE_NAME: \\cs-nice-storage\c$
File: \COMPAQ
ARCHIVE_DATE: 1900-01-01 00:00:00.000000
CLASS_NAME: DEFAULT
NODE_NAME: CS-NICE-STORAGE
FILESPACE_NAME: \\cs-nice-storage\c$
File: \COMPAQ
ARCHIVE_DATE: 1900-01-01 00:00:00.000000
CLASS_NAME: DEFAULT
NODE_NAME: CS-NICE-STORAGE
FILESPACE_NAME: \\cs-nice-storage\c$
File: \COMPAQ
ARCHIVE_DATE: 1900-01-01 00:00:00.000000
CLASS_NAME: DEFAULT
NODE_NAME: CS-NICE-STORAGE
FILESPACE_NAME: \\cs-nice-storage\c$
File: \COMPAQ
ARCHIVE_DATE: 1900-01-01 00:00:00.000000
CLASS_NAME: DEFAULT
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- select statement,
Joni Moyer <=
|
|
|