1
2
3
4
5
6
7
8
9

EXPLAIN PLAN FOR SELECT last_name FROM employees;
 
--Using EXPLAIN PLAN with the STATEMENT ID Clause
EXPLAIN PLAN SET STATEMENT_ID = 'st1' 
FOR SELECT last_name FROM employees;
 
--Using EXPLAIN PLAN with the INTO Clause
EXPLAIN PLAN INTO my_plan_table   
FOR  SELECT last_name FROM employees;