set serveroutput off
select 1 from dual where 1=2;

no rows selected

select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));

SQL> select 1 from dual where 1=2;

строки не выбраны

SQL> select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------
SQL_ID  ghugmhyrbqaqx, child number 0
-------------------------------------
select 1 from dual where 1=2

Plan hash value: 731024556

--------------------------------------------------------------------
| Id  | Operation   | Name | Starts | E-Rows | A-Rows |   A-Time   |
--------------------------------------------------------------------
|   1 |  FILTER     |      |      1 |        |      0 |00:00:00.01 |
|   2 |   FAST DUAL |      |      0 |      1 |      0 |00:00:00.01 |

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------


13 строк выбрано.

alter system set "_cursor_plan_unparse_enable" = false scope=both;