SQL & PL/SQL

Hi Team,
How to download the JSON data if we pass the URL as like below
select functionname('www.oracle.com') from dual.
please let me know how to do.
SAMPLE CODE
declare
l_req1 utl_http.req;
l_resp1 utl_http.resp;
begin
l_req1 := utl_http.begin_request('https://www.oracle.com/index.html');;)
l_resp1 := utl_http.get_response(l_req1);
utl_http.end_response(l_resp1);
end;
/

Thanks