|  | 
	| 
		
			| Re: ear multivalue json as rows [message #681460 is a reply to message #681459] | Mon, 20 July 2020 05:56   |  
			| 
				
				
					| Solomon Yakobson Messages: 3305
 Registered: January 2010
 Location: Connecticut, USA
 | Senior Member |  |  |  
	| SY.
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>
 |  
	|  |  | 
	|  |