There is a data structure in a json column
I am trying to retrieve a certain result from this column.
Тhese dates I will have to apply it to a function each date will be a parameter

The goal is to retrieve PERIOD1 05/31/2024 as date1 , PERIOD1 06/15/2024 as date2

   create table emp_json_tbl (
     emp_json CLOB

  );


   insert into emp_json_tbl values ('{"flows":{"11/21/2023":725.76,"06/14/2024"},"PERIOD1":                   "05/31/2024":115.09,"06/15/2024":14.10},"PERIOD3":{"11/21/2023":0,"06/15/2024":18.72},"PERIOD2":   {"03/31/2024":140,"06/15/2024":13}}') 


 select * from emp_json_tbl

`

Expected result; 05/31/2024 as date1
06/15/2024 as date2