Print CLOB Column content in Oracle Apex Region

We all facing to print clob content in oracle apex report region. In this post we will see how to print clob content in “PL/SQL Dynamic Content Region”. Step 1: Create PL/SQL Dynamic Content Region. Step2: Make PL/SQL script to print in a region, for example see below script. Step 3: Use HTP.P to print HTML content. Refer below link Click to See Reference That’s … Continue reading Print CLOB Column content in Oracle Apex Region

Oracle Apex JSON parsing with Nested Path

We face difficulties when we parsing nested path json content, in this post we will see how to parse using nested path with json content. before we see you need to know below names; JSON_TABLE NESTED PATH Refer this link :- Reference Oracle Document json content :- Below PL/SQL Code To Get Id from direct path and get user email from nested path Stored the … Continue reading Oracle Apex JSON parsing with Nested Path

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