我有一个具有内联函数的查询：
with function with_f(p_text in varchar2) return varchar2 is
begin
return p_text;
end;
select with_f(dummy) from dual
有没有办法在 SQL Developer 中获取该查询的解释计划？
我试过这个：
explain plan for (
with function with_f(p_text in varchar2) return varchar2 is
begin
return p_text;
end;
select with_f(dummy) from dual
);
select plan_table_output from table(dbms_xplan.display());
但我收到以下错误：
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
语句周围的括号是错误的。这是
explain plan for stmt并不是
explain plan for (stmt);db<>小提琴