JSON_QUERY: Path expression based on variables?
You can use EXECUTE IMMEDIATE to solve it.
DECLARE varpath varchar2(180):= 'testvar1.testattribute'; v_query_str varchar2(4000); v_result varchar2(4000);BEGIN v_query_str := 'SELECT JSON_QUERY(json_field FORMAT JSON , ''$.' || varpath || ''' RETURNING VARCHAR2(4000) ASIS WITHOUT ARRAY WRAPPER NULL ON ERROR) FROM example1'; EXECUTE IMMEDIATE v_query_str INTO v_result;END;