I have a query that has an inline function:
with function with_f(p_text in varchar2) return varchar2 is begin return p_text; end; select with_f(dummy) from dual
Is there a way to get the explain plan for that query in SQL Developer?
I tried this:
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());
But I get the following error:
SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"
Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.
The parentheses around the statement are wrong. It is
explain plan for stmt
explain plan for (stmt);
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0