Now my reuslt format is this:
enter image description here
I want to change it into this format (with the heading (line1)):
enter image description here
How can I edit it? Here is my sql code:
SELECT TO_CHAR (LOG_DTM,'yyyy-mm-dd') RECORD_DATE,
HOST_NAME PROCESS_HOST, USER_CD OS_USER,
SEARCH_VARCHAR_1 PCM_USER, OPERATION_CD, SEARCH_VARCHAR_2 ACC_NAME,
SEARCH_VARCHAR_3 TOOL_TYPE_CD, SEARCH_VARCHAR_4 ACC_HOST, COUNT(1) FREQUENT
FROM ALS.ALS_CENTRAL_DEBUG_LOG_3
WHERE SERVICE_CD = 'SUP_PCM_CMD'
AND ACTION_CD = 'END'
AND OPERATION_CD in ('getjobpwd', 'createaccountjob', 'savejobpwd', 'deactiveacctjob')
AND LOG_DTM between TRUNC(ADD_MONTHS(TO_TIMESTAMP('01-08-2022','DD-MM-YYYY'), -1),'MM')
AND LAST_DAY(ADD_MONTHS(TRUNC(TO_TIMESTAMP('01-09-2022','DD-MM-YYYY'),'mm'),-1))
--AND LOG_DTM between TRUNC(ADD_MONTHS(SYSDATE, -1),'MM')
--AND LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE,'mm'),-1))
GROUP BY LOG_DTM, HOST_NAME, USER_CD, SEARCH_VARCHAR_1, OPERATION_CD, SEARCH_VARCHAR_2, `
SEARCH_VARCHAR_3, SEARCH_VARCHAR_4;
