APEX to extract JSON ARRAY structure into table. Error JZN-00211
Hi to all, we need to read this json format and write in a relational table,
this is the JSON FORMAT :
'{"lastUpdateId":10563648449,"bids":[["58999.99000000","0.10705400"],["58998.97000000","0.15232600"],["58995.54000000","0.02962200"],["58995.53000000","0.00108400"],["58993.29000000","0.04216300"]],"asks":[["59000.00000000","3.92435300"],["59000.01000000","0.04115200"],["59000.65000000","0.17911800"],["59003.10000000","0.08673100"],["59005.89000000","0.02280500"]]}'
The format is lastupdateid=unixtime, bids (price,quantity(,(price,quantity),...5 times and
asks (price, quantity),(price,quantity),... 5 times.
The times are variables, so we need a instruction to get the number of iterations in bids and asks.
This is the oracle table :
create table opertest (
Id number, pre_b number, cant_b number, pre_a number, cant_a number);
The expected Result is :
LastupdateID B_price B_quant A_price A_quant
--------------- --------- --------- ------ ------