SELECT 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