How to convert a Row output of a sql query into columns

I am trying to generate a report which is pulling information from a table which has CLOB 

but it gives result in single row including all columns because its a CLOB but i need separate columns as output. 

This is the query I am using 

SELECT TARGET_NAME,JOB_TIME,ACCOUNT_DETAILS FROM (

SELECT '===============' TARGET_NAME,'================' JOB_TIME,'==================================================' ACCOUNT_DETAILS FROM DUAL

UNION

SELECT

TARGET_NAME,

TO_CHAR(END_TIME,'DD-MON-RRRR HH24:MI:SS') JOB_TIME,

TO_CHAR(REGEXP_SUBSTR(mh.OUTPUT,'[^@]+', 1,ct.x)) ACCOUNT_DETAILS

FROM MGMT$JOB_STEP_HISTORY mh,