Need Oracle APIs for decoding the encoded string and access the URL and read the data
Hi All,
Just would like to know if the below steps are possible in Oracle DB. Do we have any inubuilt APIs to achieve the same. Our Database version is 19.0.0.0.0
We will have the encoded URL. Using Oracle APIs, we need decode the encoded URL, using UTF-8 source character set and Base64 decoding, to obtain the URL link
Once decoded, need to hit the URL to get the JSON/XML file and read the data