Oracle Magazine, September/October 2018
Database Developer LOW CODE ensure that the value of the P2_ SEARCH text item will be submitted to the Oracle APEX engine when the region is refreshed 12 Click the Run Application icon on the upper right to save all your changes and run your Oracle APEX application Your application should look similar to Figure 4 Enter any search term you wish such as tupac or your favorite music artist and click Go You now have an application that uses the iTunes Search API which makes a request via HTTP returns the results in JSON and parses the results before further manipulating the results via SQL postprocessing Figure 4 The application with a search field for dynamic searching of the iTunes music video catalog ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 84
You must have JavaScript enabled to view digital editions.