Mostly Making oracle easy, mostly:
  • A quick note on Creating PDBs using REST APIs with ORDS
  • Introducing SQL Developer Web to Oracle Cloud Infrastructure
  • Execution plans in Oracle SQL Developer for VS Code
  • Definitive guide to moving from SQL Developer to VS Code
  • Oracle VirtualBox 23ai FREE Database Appliance updated: 23.6
  • Oracle SQL Developer 24.3.1 is now available
  • Oracle SQL Developer Extension for VS Code 24.4 available
  • How to upload multiple files in 1 call: multipart/form-data
Search for:
  • X (Twitter)
  • YouTube
  • LinkedIn
ThatJeffSmith ThatJeffSmith
  • SQLDev / VS Code
  • SQLDev Web
  • REST APIs
  • Data Modeling
  • Ask A Question
  • About
  • Search for:
Tag

json_table

Browsing
In Database Stuff

Retrieve DISTINCT list of values from JSON arrays via SQL

May 21, 2024 3 Mins Read
  • Looking for help?

    I'm a product manager for Oracle Database,
    publishing tips and tricks for SQL Developer, SQLcl, Data Modeler, and REST Data Services (ORDS)

    X (Twitter) YouTube LinkedIn
  • Search this site
  • Mostly Making Oracle Easy, Mostly

    Privacy Policy 

  • X (Twitter)
  • YouTube
  • LinkedIn
  • Try our new SQL Developer Extension for VS Code
  • Developer Tools Message Boards

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle. © Jeff Smith and ThatJeffSmith, 2024

Top
ThatJeffSmith