The DBMS_XPLAN DISPLAY Function displays an execution plan from a PLAN_TABLE
The function returns a DBMS_XPLAN_TYPE_TABLE
In Oracle 12.1.0.2 the function takes the following parameters:
Argument Name | Type | In/Out | Default? |
TABLE_NAME | VARCHAR2 | IN | DEFAULT |
STATEMENT_ID | VARCHAR2 | IN | DEFAULT |
FORMAT | VARCHAR2 | IN | DEFAULT |
FILTER_FEEDS | VARCHAR2 | IN | DEFAULT |