OracleRESTHandlerSplitPayload

Oracle REST Handler Split Payload是Oracle数据库中的一个函数，用于将JSON或XML格式的数据解析成多个表格行并插入到表格中。以下是一个示例代码：

declare
    l_clob clob := '{"employees":[{"name":"John Doe","age":27},{"name":"Jane Doe","age":25}]}';
begin
    apex_json.initialize_clob_output;

    apex_json.open_object;
    apex_json.write('employees');
    apex_json.open_array;

    for i in 1..apex_json.get_count(p_path => 'employees') loop
        apex_json.open_object;
        apex_json.write('name', apex_json.get_varchar2(p_path => 'employees[%d].name', p0 => i));
        apex_json.write('age', apex_json.get_number(p_path => 'employees[%d].age', p0 => i));
        apex_json.close_object;
    end loop;

    apex_json.close_array;
    apex_json.close_object;

    apex_json.get_clob_output := true;

    insert into employees(name, age)
    select name, age
    from json_table(l_clob, '$.employees[*]'
    columns(
        name varchar2(50) path '$.name',
        age number path '$.age'
    ));
end;

这段代码将JSON格式的字符串解析成多个表格行，并将其插入到名为“employees”的表格中。最后，我们使用“json_table”函数将JSON数据转换为表格行。