One more way we can see the Explain Plan by using DBMS_XPLAN package.
- DBMS_XPLAN automatically queries the last plan in PLAN_TABLE.
- It uses a TABLE() function with another pipelined function.
Example of DBMS_XPLAN:
select * from table(dbms_xplan.display);
