Check if you are looking something like this..
If not, could you please share your sample JSON data and table structure. will help us to address your query.
I'm getting errors with the following code. is there way to use APEX JSON APIs for fetching the request and processing it as CLOB file?, thanks for your help.
l_request := utl_http.begin_request(url => l_url,method =>'GET');
ORA-29273: HTTP request failed