Parse json data using APEX_JSON in Oracle PL SQL

How to parse JSON data in oracle apex ? Yes, We can parse json data with the help of apex_json and apex_json.t_values. User apex_web_service.make_rest_request Authorization method is Bearer Token Store the response in CLOB variable Parse the response json content with apex_json.t_values Count no of rows in json content Create for loop and get the object values using apex_json.get_varchar2 Insert / Update object value variables … Continue reading Parse json data using APEX_JSON in Oracle PL SQL