Conversely, JSON data can also be generated from the content of relational columns. If you are working with Oracle Application Express (APEX), for example, you can generate JSON documents using the APEX_JSON function. Another option is the line mode tool SQLcl. The format command "SET SQLFORMAT JSON", for example, automatically displays output in JSON format. With Oracle database version 12.2, there is a third option - even using pure SQL tools.
With new SQL/JSON functions such as JSON_OBJECT, JSON_ARRAY or JSON_ARRAYAGG, JSON documents can be generated in the source code from SQL queries or in PL/SQL procedures. For example, you can then use a single SQL statement to output the customers per country and their associated information from the NAME, STATUS, CITY and STREET columns in a JSON array. The CUSTOMERS and COUNTRIES tables from the demo example schema SH are used for this.
Easy access to JSON data
To ensure easy use of belize telegram screening JSON information in the database, special SQL functions and operators have been introduced. In the simplest case, the data can be accessed using dot notation. This requires the use of the check constraint IS JSON and the use of a table alias (here j) in the query itself.
Similar to accessing XML documents, there are also new functions available for the special use of JSON access. If you prefer to work with JSON expressions instead of dot notation or if the queries are more complex, you can use the JSON_VALUE function, for example. In the following example, the first element from the Phone field of ShippingInstructions (here