Getting to grips with JSON in the database
With Oracle 21c and 23c, JSON in the database is now a reality. Mixed relational-JSON databases are on the verge of becoming mainstream.
In this session, using practical examples in the Oracle Cloud, we'll look at:
Generating JSON objects from relational data using SQL and PL/SQL
- JSON_OBJECT
- JSON object types
- apex_json
Using JSON objects in PL/SQL
- dot notation
- parsing JSON
- json_table
- json_query
Presenting JSON objects as relational
- relational joins with JSON data
Manipulating and updating JSON objects from PL/SQL
- json_transform
Indexing JSON data
- simple index
- multi-value indexes
- search indexes
Tagged under
Related items
- SQL: Good and evil are the same thing
- SQL: Good and evil are the same thing
- My view on Oracle’s position in Gartner Magic Quadrants for Analytics and Business Intelligence Platforms
- My view on Oracle’s position in Gartner Magic Quadrants for Analytics and Business Intelligence Platforms
- Oracle The Most Mysterious Cases
Leave a comment
- Speaker:
- Niall Mc Phillips
- Podjetje
- Long Acre