Oracle APEX: Intro to SODA Collections (JSON) in SQL Worksheet
In this short tutorial we will showcase how Oracle APEX (free tier) can quickly consume and leverage json documents in a matter of minutes. This 101 tutorial will begin with the creation of a SODA collection in SQL Workshop including a Data Load. We will then show how to easily:
Append more documents to the collection in SQL workshop and Database Actions
Query the raw json
Update Nested JSON elements through JSON_TRANSFORM and JSON_MERGEPATCH
Understand and query the default soda collection view in SQL.
Query the collection using javascript syntax in SQL Workshop.
Create a custom view in SQL Worksheet.
Example SQL statements are posted here:
https://github.com/chipbaber/apex_tex...
Related example:
• How to Connect Postman to Autonomous ...
#oracle #apex #json #sodacollections #query #oci #autonomous #atp #adb #codeinnovate