By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
jt.company,
jt.title
FROM
JSON_TABLE(
'{
"past_work": [
{"company": "XXXXX", "title": "XXXX"},
{"company": "YYYYY", "title": "YYYY"}
]
}',
'$.past_work[*]'
COLUMNS (
company VARCHAR2(100) PATH '$.company',
title VARCHAR2(100) PATH '$.title'
)
)
AS jt
| COMPANY | TITLE |
|---|---|
| XXXXX | XXXX |
| YYYYY | YYYY |