7 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.

Topics

• About the JSON User Interface

• Managing JSON Collections

• About Querying Documents in a Collection

• Creating Indexes for JSON Collections

• Creating Relational Views of JSON Documents

• Viewing the JSON Data Guide Diagram for a Collection

See Also:

SODA Overview in Oracle Database Introduction to Simple Oracle Document Access (SODA)