select inst_id, -- INST_ID NUMBER id, -- ID NUMBER decode( -- TYPE VARCHAR2(14) type, 0, 'RUN', 1, 'RUN-RESUME', 2, 'FINDING', 3, 'RECOMMENDATION', 'UNKNOWN'), name, -- NAME VARCHAR2(32) value -- VALUE VARCHAR2(513) from x$dbkinfo