DBMS_XPLAN DISPLAY_CURSOR Function

The DBMS_XPLAN DISPLAY_CURSOR function displays an execution plan from the library cache

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?
SQL_ID VARCHAR2 IN DEFAULT
CURSOR_CHILD_NO NUMBER(38) IN DEFAULT
FORMAT VARCHAR2 IN DEFAULT