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:

Related example:

#oracle #apex #json #sodacollections #query #oci #autonomous #atp #adb #codeinnovate