SELECT
  INST_ID,                                 -- INST_ID NUMBER
  NAME_SKGXPIA,                            -- NAME VARCHAR2(35)
  IP_SKGXPIA,                              -- IP_ADDRESS VARCHAR2(16)
  decode(                                  -- IS_PUBLIC VARCHAR2(3)
    PUB_SKGXPIA, 'Y', 'YES', 'N', 'NO'),
  decode(                                  -- SOURCE VARCHAR2(31)
    PICKED_SKGXPIA, 'OSD', 'OS dependent software', 'OCR', 'Oracle Cluster Repository', 'CI', 'cluster_interconnects parameter') 
FROM
  X$SKGXPIA