select INST_ID, -- INST_ID NUMBER PLATFORM_ID, -- PLATFORM_ID NUMBER PLATFORM_NAME, -- PLATFORM_NAME VARCHAR2(101) decode( -- ENDIAN_FORMAT VARCHAR2(14) endian_format, 1,'Big' ,0,'Little','UNKNOWN FORMAT') from x$kcpxpl where endian_format = ( select endian_format from x$kcpxpl pl, x$kccdi di where pl.platform_id = di.diplid)