The DBMS_XPLAN DISPLAY_PLAN Function returns an execution plan as a CLOB
The function returns a CLOB
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 |
| TYPE | VARCHAR2 | IN | DEFAULT |