There are "json, json_value, and json_list" types for Oracle 11g:
Put in json:
- https://jsao.io/2015/07/relational-to-json-with-pljson/
- http://www.toadworld.com/platforms/oracle/w/wiki/11661.introduction-to-json-with-oracle-database
Get json:
Important links:
- https://www.morganslibrary.org/reference/pkgs/utl_tcp.html
- http://alex-td.blogspot.mx/2013/02/invoking-restful-web-service-in-oracle.html
- http://orclapex.blogspot.mx/2014/04/calling-apis-from-plsql-using-utlhttp.html
- https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services
- https://community.oracle.com/thread/1037981
- https://stackoverflow.com/questions/25807835/old-sql-history-in-oracle-sql-developer
Best regards,
