By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT * FROM JSON_TABLE (('
{
"tipodenunciaid": [1,2,3,4],
"municipioid": [1,2,3,4,5]
}
'), '$.tipodenunciaid[*]' COLUMNS (rn for ordinality, tipodenunciaid integer PATH '$'));
| RN | TIPODENUNCIAID |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
with
data as (
select '{ "tipodenunciaid": [1,2,3,4], "municipioid": [1,2,3,4,5] }' as js from dual
),
t as (
select t.*
from data d
cross apply json_table(
d.js,
'$.tipodenunciaid[*]' columns (rn for ordinality, tipodenunciaid integer path '$')
) t
),
m as (
select m.*
from data d
cross apply json_table(
d.js,
'$.municipioid[*]' columns (rn for ordinality, municipioid integer path '$')
) m
)
select t.tipodenunciaid, m.municipioid
from t
full join m on m.rn = t.rn
| TIPODENUNCIAID | MUNICIPIOID |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| null | 5 |