JSON_KEY_LIST

JSON_KEY_LIST是一个VARCHAR(4000)类型的变长数组，用于存储JSON_OBJECT_T对象的属性名。JSON_OBJECT_T调用get_Keys函数返回JSON_KEY_LIST。

示例

create or replace procedure proc1 as
	jo json_object_t;
	ja json_array_t;
	keys json_key_list;
	keys_string varchar2(100);
begin
	jo:=json_object_t('{"name":"fred","jobTitle":"codemonkey","projects":["json","xml"]}');
	ja:=json_array_t();
	keys:=jo.get_keys;
	for i in 1..keys.count loop
		ja.append(keys(i));
	end loop;
	keys_string:=ja.to_string;
	dbms_output.put_line(keys_string);
end;

/
exec proc1;
drop procedure proc1;