HI Experts,
I have this query, and I want to take this output in excel tab format for first select statement output in first excel tab, next select statement output in next excel tab, next select statement output in next excel tab
for the same sheet and output to store in a file and send to customer through script.
SELECT
I_IDX,
I_RESOURCEINDEX,
-- I_START_DATE,
CASE
WHEN I_HOSTCFNAME IS NULL
THEN I_HOSTNAME
ELSE I_HOSTCFNAME
END AS HOSTNAME,
I_SENAME,
I_IFALIAS
CASE
WHEN I_IFALIAS IS NOT NULL THEN I_IFALIAS
WHEN I_IFALIAS IS NULL AND I_IFDESCR IS NOT NULL THEN I_IFDESCR
ELSE REGEXP_REPLACE(I_SENAME, '(Delete|Disconnected|Burned)_[0-9]+_', 'bpit)
END AS IETFNAME,
I_IFSPEED_STR,
I_IFSPEED,
M_AVG_IN_UTIL_BH,
M_MAX_IN_UTIL_BH,
M_OUT_DISCARDS_BH,
M_AVG_AVAIL_BH
FROM ietfs_basf_proviso,
metrics_basf_proviso
WHERE ietfs_basf_proviso.I_RESOURCEID = metrics_basf_proviso.M_RESOURCEID;
Please provide your assistance on this.