select INST_ID, -- INST_ID NUMBER QESRCMEM_LAD, -- ID NUMBER QESRCMEM_CNK, -- CHUNK NUMBER QESRCMEM_BLK, -- OFFSET NUMBER decode( -- FREE VARCHAR2(3) QESRCMEM_STA, 0, 'NO', 1, 'YES'), decode( -- OBJECT_ID NUMBER QESRCMEM_STA, 0, QESRCMEM_OID, NULL), decode( -- POSITION NUMBER QESRCMEM_STA, 0, QESRCMEM_POS, NULL) from x$qesrcmem