with response as (
    select get_gpt_response('What is the capital of United States?') as data
    from dual
)
select
    jt.*
from response r,
    json_table(
        r.data,
        '$'
        columns(
            id                varchar2(50)   path '$.id',
            answer            varchar2(1000) path '$.choices[0].message.content',
            prompt_tokens     number         path '$.usage.prompt_tokens',
            completion_tokens number         path '$.usage.completion_tokens',
            total_tokens      number         path '$.usage.total_tokens'
        )
    ) jt;