Working with JSON-Relational Duality Views

A JSON-relational duality view exposes data stored in relational database tables as JSON documents. These documents are generated on demand. Duality views organize your data both relationally and hierarchically. This means that applications can access (create, query, modify) the same data as a set of JSON documents or as a set of related tables and columns, and both approaches can be employed at the same time.

For more information about JSON- Relational Duality Views, see Oracle® Database JSON-Relational Duality Developer’s Guide.

In the SQL Developer extension for VS Code, Duality View is treated as an object type and is available as a separate node in the Connections panel. The tasks that you can perform are:

• Create a duality view using the Duality View Builder.

• Edit a duality view.

• Insert a data record in a duality view.

• Edit a data record in a duality view.

• Display the JSON Data Guide Diagram for a duality view.