declare
    sample_json   varchar2 (32767)
        := '{

            "NAME":"AUDI","YEAR":"2000","NAME":"BMW","YEAR":"2010"
}';
begin
    apex_json.parse (sample_json);
    dbms_output.put_line (apex_json.get_varchar2 ('NAME'));
    dbms_output.put_line (apex_json.get_varchar2 ('YEAR'));
end;

{"NAME":"AUDI","YEAR":"2000","NAME":"BMW","YEAR":"2010"}

{"NAME":"BMW","YEAR":"2010"}

[{"NAME":"AUDI","YEAR":"2000"},{"NAME":"BMW","YEAR":"2010"}]