column num format 999
column txt format a11
column tim format a29
select *
from
json_table( json_array( 42, 'Hello world', systimestamp ),
'$' columns (
num number ( 3) path '$[0]',
txt varchar2 (20) path '$[1]',
tim timestamp path '$[2]'
)
);
--
-- NUM TXT TIM
-- ---- ----------- -----------------------------
-- 42 Hello world 2023-09-20 09:07:57.933246000
select *
from
json_table( json_array( 42, 'Hello world', systimestamp ),
'$[*]' columns (
col varchar2(50) path '$[0]'
)
);
--
-- COL
-- --------------------------------------------------
-- 42
-- Hello world
-- 2023-09-20T11:20:45.011805Z