|
Re: ear multivalue json as rows [message #681460 is a reply to message #681459] |
Mon, 20 July 2020 05:56   |
Solomon Yakobson
Messages: 3214 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
with sample as (
select 'mystring' col1,
'{"keys":["25094","36316","36317","40836","45223"]}' col2
from dual
)
select col1,
key
from sample,
json_table(
col2,
'$.keys[*]'
columns
key number path '$'
)
/
COL1 KEY
-------- ----------
mystring 25094
mystring 36316
mystring 36317
mystring 40836
mystring 45223
SQL>
SY.
|
|
|
|