5 The JSON Page
Note:
Available for Oracle Database release 19c and later releases and only if you signed in as a database user with the SODA_APP role.Use the JSON page in Database Actions to view and manage
JSON collections, search for collection items using Query-by-Example (QBE), create JSON
search indexes and display data guide diagrams for collections.
To navigate to the JSON page, do either of the following:
-
In the Launchpad page, select the Development tab and click JSON.
-
Click Selector
to display the navigation menu. Under
Development, select JSON.
- About the JSON User Interface
The JSON user interface consists of the left pane for listing and searching saved collections and the right pane for viewing and managing documents in a collection. - Managing JSON Collections
You can add, view or drop collections, or browse, add, edit and delete JSON documents in a collection. - About Querying Documents in a Collection
You can search for one or more documents in a collection by using a filter specification or Query-by-Example (QBE). - Creating Indexes for JSON Collections
- Creating Relational Views of JSON Documents
- Viewing the JSON Data Guide Diagram for a Collection
The diagram view displays the JSON data guide for a collection as a hierarchical structure using a format similar to entity-relationship diagrams.
Parent topic: Development