I want to get something like:
sample_dt sd0 sd1 sd2
01/01/2001 25 25 0
01/02/2001 30 30 25
I am looking for a generic query solution. I know that I can write a stored procedure to generate the query, but that would take some time. I know that to solve this exact problem, I could write a query with hardcoded values, but as I say, I am looking for a generic solution where the number of device_cd's will vary.
05-07-2001, 02:18 PM
Here is a short SQL*PLUS script that should do the trick.
set head off feedback off verify off term off
select 'select sample_dt' from dual;
select ' from disk_utilization group by sample_dt;'
set head on term on