另一种方法，使用for循环：

declare
    l_json_in clob;
    l_json_obj json_object_t;
    l_json_arr json_array_t;
    l_json_out clob;
begin
    l_json_in := '{"List": ["abc","xyz","edf","cbz"]}';
    
    l_json_obj := json_object_t.parse(l_json_in);
    l_json_arr := l_json_obj.get_array('List');
    
    FOR i IN 0 .. l_json_arr.get_size - 1 LOOP
        dbms_output.put_line(l_json_arr.get_string(i));
    END LOOP;
end
;

nb：假设所有元素都是字符串

我找到了答案：

with json as(select '{"List": ["abc","xyz","edf","cbz"]}' txt
from dual)
select value val
from json_table((select txt from json), '$.List[*]'
        columns(value PATH '$')
)
;