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
where
  endian_format = (
  select
    endian_format
  from
    x$kcpxpl pl,
    x$kccdi di
  where
    pl.platform_id = di.diplid)