select x$kccor.inst_id, -- INST_ID NUMBER orrid, -- RECID NUMBER orstm, -- STAMP NUMBER ordfp, -- FILE# NUMBER to_number(orofs), -- OFFLINE_CHANGE# NUMBER to_number(orons), -- ONLINE_CHANGE# NUMBER to_date( -- ONLINE_TIME DATE oront,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), to_number(orrls), -- RESETLOGS_CHANGE# NUMBER to_date( -- RESETLOGS_TIME DATE orrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') from x$kccor