for example:
declare
v_result clob;
begin
EXECUTE IMMEDIATE 'SELECT JSON_ARRAYAGG(JSON_OBJECT(*)) FROM (select empno, ename, sal from emp order by sal)' into v_result;
DBMS_OUTPUT.PUT_LINE(v_result);
end;
The returned json dataset in v_result is not in order by sal.
