PLSQL解析JSONList

PLSQL解析JSONList

PLSQL 解析JSON List

declare

  list_value json_list := json_list('[{"code":"1","name":"Tom"},{"code":"2","name":"Jack"},{"code":"3","name":"Mike"},{"code":"4","name":"Mary"}]');

  code_value varchar(10);

  name_value varchar2(100);

begin

  dbms_output.put_line('Count = '||list_value.count);

  for i in 1 .. list_value.count

  loop

    code_value := pljson_ext.get_string(json(list_value.get(i)),'code');

    name_value := pljson_ext.get_string(json(list_value.get(i)),'name');

    dbms_output.put_line('code = ' || code_value || '; name = ' || name_value ); 

  end loop;

end;

结果

Count = 4

code = 1; name = Tom

code = 2; name = Jack

code = 3; name = Mike

code = 4; name = Mary

--刘轶鹤