- Using Guide for Oracle Cloud
- Development
- The JSON Page
- Creating Relational Views of JSON Documents
Creating Relational Views of JSON Documents
- In the JSON page, click
New Collection View in the right pane.
- Enter the following fields:
-
View Name: Enter a name for the view.
-
Select columns to add: Click in this field to view the list of available properties and to select the required properties, adding them one at a time. Alternatively, select Add All to add all objects and arrays with all their properties. Select one or several properties and move them up or down to position them in the resulting view. Objects and arrays are moved or deleted together with all their properties.
You can edit the Column Name attribute for each column, and for string types, you can also edit the Length attribute. Precision and scale can be set for numeric properties, for example, (10,2).
-
- Click Test Query to review the DDL statements before creating the
view.
Click Create to create the view, or click Definition to return to the previous screen and make changes to the corresponding attributes.
The created view is now available in the SQL page.