Breaking News: Grepper is joining You.com. Read the official announcement!

oracle select json_table example

Alex Latorre answered on February 28, 2022 Popularity 8/10 Helpfulness 5/10

answer oracle select json_table example

oracle select json_table example

Comment

-- EXAMPLE TABLE STRUCTURE:
CREATE TABLE LDAP_USERS.API_LOG
(
  DATETIME  	DATE,
  JSONCOLUMN    CLOB
)

-- JSON STRUCTURE:
{ keyname1: value1, keyname2: value2, ... }

-- SELECT EXAMPLE
SELECT a.*, j.*
  FROM YOURSCHEMA.yourtable a, 
  JSON_TABLE ( a.JSONCOLUMN,
               '$'  COLUMNS(
                     keyname1 VARCHAR(10) PATH '$.keyname1',
                     keyname2 VARCHAR(10) PATH '$.keyname2'
                     )
            ) as j

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: oracle select sql

Link to this answer
Share Copy Link

Contributed on Feb 28 2022

Alex Latorre

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

oracle select json_table example

Contents

More Related Answers

oracle select json_table example

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.