create table t (  
  bd   binary_double,  
  bf   binary_float,  
  clb  clob,  
  blb  blob,  
  nc   nvarchar2(10),  
  rw   raw(10),  
  tstz timestamp with time zone,  
  tslz timestamp with local time zone,  
  ymi  interval year to month,  
  dsi  interval day to second  
) 

insert into t values (  
  binary_double_nan, binary_float_infinity, to_clob('clob'), to_blob(hextoraw('12345ABCEF')), 'nvarchar2',   
  hextoraw('12345ABCEF'), systimestamp, systimestamp, interval '1' month, interval '1' day  
) 

select * from t 

select json_array (    
  bd, bf, clb, blb, rw, nc, tstz, tslz, ymi, dsi    
)    
from   t

select json_object (    
  'binaryDouble'               value bd,    
  'binaryFloat'                value bf,    
  'clob'                       value clb,    
  'blob'                       value blb,    
  'nvarchar2'                  value nc,    
  'raw'                        value rw,    
  'timestampWithTimeZone'      value tstz,     
  'timestampWithLocalTimeZone' value tslz,     
  'intervalYearToMonth'        value ymi,     
  'intervalDayToSecond'        value dsi    
)    
from   t