SELECT *
  FROM json_table('[{id:"A10",cost:50,price:175,profit:125},
                    {id:"B5",cost:20,price:80,profit:60},
                    {id:"C42",cost:5,price:25,profit:20}]', '$[*]'
       COLUMNS (item_id VARCHAR2(255) PATH '$.id',
                item_cost NUMBER PATH '$.cost',
                price NUMBER PATH '$.price',
                profit NUMBER PATH '$.profit'))