|
-
This simple SQL*PLUS script should do the trick.
set head off feedback off verify off term off
spool disk_util.sql
select 'select sample_dt' from dual;
select distinct
',min(decode(device_cd,'''||device_cd||''',utl_pct)) '||device_cd
from disk_utilization;
select ' from disk_utilization group by sample_dt' from dual;
spool off;
set head on term on
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|