select inst_id, -- INST_ID NUMBER fid, -- ADVISE_ID NUMBER rank, -- RANK NUMBER decode( -- REQUIRED VARCHAR2(3) bitand(flags,65536), 0, 'NO', 'YES'), reco_msg -- MESSAGE VARCHAR2(1024) from x$dbkreco where type = 0